another question on forcing to new line

  • Thread starter Thread starter sheela
  • Start date Start date
S

sheela

In my report, I am using a text box to print values from
multiple fields. I specify the field names in the control
source property of the text box.
I need to print each field value in a separate line. The
vbcrlf is not working, in the properties window. How do I
specify to go next line in the properties?
TIA,
Sheela
 
sheela said:
In my report, I am using a text box to print values from
multiple fields. I specify the field names in the control
source property of the text box.
I need to print each field value in a separate line. The
vbcrlf is not working, in the properties window. How do I
specify to go next line in the properties?
Click to expand...


vbCrLf is a VBA constant. It is not known in the Control
Source expression environment.

Use Chr(13) & Chr(10) instead.
 
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

Force a new line in Access text box 10
text box in report is truncating memo field at 255 characters 2
How do I force a memo field to print all text in reports? 2
Ignore blank lines in report text box 3
Line drawing on report 0
Change text box background color depending on value in Label Reports 1
Force page every 20 records. 7
Stuck on group header expression 4

Back
Top