hard return or paragraph mark..line drop.. in an Access Query..what is the code?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm construction a calculated text string in an Access
query. I need the query to output hard return..drop down a
line.. within the calculated string. Access forces a line
drop to change to a space.. arrrrggh. does anyone know how
to force Access to read the paragraph mark, the hard
return? I've added "
" before which seemed to work..but not now..
should it be something & p or?
thanks.
 
Try

TextString1 & Chr(13) & Chr(10) & TextString2.

You must insert a carriage return and a line feed. vbCrLF is a visual basic
constant and SQL will not recognize Visual basic constants and variables.
 
No problem. I just hope that when I "goof" someone will back me up. And I've
been corrected many times.
 
John Spencer (MVP) said:
Re: hard return or paragraph mark..line drop.. in an Access Query..whatis the code?

Try

TextString1 & Chr(13) & Chr(10) & TextString2.

You must insert a carriage return and a line feed. vbCrLF is a visual basic
constant and SQL will not recognize Visual basic constants and variables.

> >
Click to expand...


hey, i registered just to say THANK YOU!!!!!!!
 
Back
Top