Force carriage return in text box on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to insert a forced carriage return in a textbox on a report. But when
I use this code:

txtMeetOrExceed = "NOT" & vbCrLf & "Within Range"

all I see on the report is NOT.

I have tried enlarging the textbox, but that doesn't seem to be the problem.
Any ideas?
 
Did you enlarge vertically or horizontally? Is the text box set to Can Grow:
Yes?
Is this in code somewhere? Where is the code and why are you using code?
 
Did you enlarge vertically or horizontally?
Both

Is the text box set to Can Grow: Yes?
Yes

Where is the code and why are you using code?
 
Is the control source of the text box "txztMeetOrExceed" blank? Have you
tried
Me.txtMeetOrExceed = "NOT" & Chr(13) & Chr(10) & "Within Range"

Can you share the code?
 
I just realized that I had mistakenly set the format property in this text
box to "Currency". After I removed it, the vbCrLf worked fine. Sorry for
wasting your time. Thanks for you help.
 
Back
Top