Carriage return in a text box in a textbox in report.

G

Guest

Hi! Who knows, why this code make a space but not carriage return?


Me.txtText = rs("companyName") & Chr(13) & Chr(10) & "text1"

When just change ADO RS to a simple text, carriage is working.
 
K

krissco

Hi! Who knows, why this code make a space but not carriage return?

Me.txtText = rs("companyName") & Chr(13) & Chr(10) & "text1"

When just change ADO RS to a simple text, carriage is working.
Click to expand...

Try:
Me.txtText = Cstr(Nz(rs("companyName"), "")) & Chr(13) & Chr(10) &
"text1"

-Kris
 

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

Split data in field on character return 0
how to insert CRLF (carrage return/line feed) in report 8
Trouble with chr(13) & chr(10) in IIF statement 3
CHR(13) not working for carriage return 4
Inserting carriage return in report field 3
Address box with IIf Statement 7
Report control: hide blank row when null data 2
Carriage Return in Report - Textbox 4

Top