Need to add a line

A

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!
 
J

Jeff Boyce

Anne

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

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top