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.
 
Back
Top