Need to add a line

[Anne]

I am parsing data from a field and want to add a break (instead of a comma)
so a list is created:

While Not rst.EOF
strTmp = strTmp & rst(strFieldName).Value & ", "

Thanks for your help!

 

[Jeff Boyce]

Anne

Take a look at vbCRLF (a carriage return and a line feed)...

Regards

Jeff Boyce
Microsoft Office/Access MVP