vbNewLine in text box...

Mike Eghtebas
Mike Eghtebas used Ask the Experts™
on
In MS Access I have a text box with:

= "A" & vbNewLine & "B"

to force it show like:

A
B

In preview mode. vbNewLine doesn't work.

Question: How to could work?

ctrl + vbNewLine maybe?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
HI,

is Multiline property = true

Regards
Database Architect / Application Developer
Top Expert 2007
Commented:
"A" & Chr(13) & Chr(10) & "B"
Mike EghtebasDatabase and Application Developer

Author

Commented:
Thank you.
Mike EghtebasDatabase and Application Developer

Author

Commented:
@Rgonzo1971,

There is no Multiline property property (MS Access 2013, text box on a report).

Mike
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Sure.  The vbNewLine only works in VBA code

mx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial