Query expression to include a <CR> and <LF>

[cjLiteStep]

i am trying to write a query expression to put the name and address fields on an invoice report.
i am writing an expression so blank fields won't take up a line ( i just use iif and isnull ) but i can't figure out how to add a carriage return and linefeed; it doesn't seem to like vbcrlf or chr$(10) & chr$(13);
does it have to do with the text box maybe?
when i do the report, instead of new lines I get little square boxes (2)
appreciate any help

cj

 

[link9]

try vbcr -- (visual basic carriage return)

that works in asp, but I'm not sure if it will work in access -- worth a shot, though.

 

[cjLiteStep]

thanks link9
i gave it a quick try but no go; i'll be working on though
cj