access forms carriage return instead of commas

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

Guest

Any one know how to display query information in a form split onto seperate
lines ie. with carriage return? Seperated on a new line

I want to see the names and addresses displayed as you see them below so I
can copy and paste onto a letter head:
Miss S Harris
54 Highfields Road
Birmingham
B91 1ST
Not all on one line Miss S Harris, 54 Highfields Road, Birmingham, B91 1ST
using [1stName ] &", "&[2ndName ] etc
 
Any one know how to display query information in a form split onto seperate
lines ie. with carriage return? Seperated on a new line

I want to see the names and addresses displayed as you see them below so I
can copy and paste onto a letter head:
Miss S Harris
54 Highfields Road
Birmingham
B91 1ST
Not all on one line Miss S Harris, 54 Highfields Road, Birmingham, B91 1ST
using [1stName ] &", "&[2ndName ] etc
Click to expand...

In Access use:

MailAddress:[1stName ] &", "&[2ndName ] & chr(13) & chr(10) & [Street]
& chr(13) & chr(10) & etc.....

In VBA you can also use vbNewLine or vbCrLf.
 
Back
Top