cjLiteStep
Technical User
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
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