MS Access - forcing a new line in a report text box using Expression Builder
Posted on 2009-05-14
I am trying to force a new line in a text box in a report in MS Access. For example, one of the things I am trying to do is build an address block. I am a relative neophyte to Access, so I've been using the expression builder. Things that I've tried so far:
=[Name] & vbcrlf & [Address] & vbcrlf & [Citystatezip]
- MS access adds brackets around the vbcrlf and it shows up as a query prompt when i run the report
=[Name] & "
" & [Address] & "
" & [Citystatezip]
- The carriage returns in the quotes are interpreted as an open square - all on one line.
Any other suggestions? If this is only possible outside of expression builder, please make your explanation as simple as possible, since I am new!
THank you in advance!