vbCrLf equivalent in Access Reports

  • Thread starter Thread starter epoh97 via AccessMonster.com
  • Start date Start date
E

epoh97 via AccessMonster.com

Is there an equivalent to vbCrLf in Access Reports to get a Carriage Return
in a field?
 
epoh97
When entering long text into a text control, Ctrl-Enter will cause a new line while
typing.
OR, setting the Enter Key Behavior property for the control to New Line will cause the
Enter key, during typing, to force a new line.
 
Is there an equivalent to vbCrLf in Access Reports to get a Carriage Return
in a field?
Click to expand...

In a Report?
chr(13) & chr(10)

As control source of an unbound text control:

="This is line 1." & chr(13) & chr(10) & "This is line 2."
 
Thank you FregG that worked and yes that is what I was looking for.
 
You must log in or register to reply here.

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

Similar Threads

vbCrLf error 2
Force carriage return in text box on report 4
Carriage Return - HELPQ!! 1
TAB Character in a Report 3
Outlook Cannot access more than the Outlook VBA 250 Mail Items 1
no data message 2
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
line feed not showing in report 4

Back
Top