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

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

John Spencer (MVP)

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

John Spencer (MVP)

No problem. I just hope that when I "goof" someone will back me up. And I've
been corrected many times.
 
Joined
Jan 25, 2016
Messages
1
Reaction score
0
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.

> >


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top