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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top