Force carriage return in text box on report

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?
 
D

Duane Hookom

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?
 
G

Guest

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?
 
D

Duane Hookom

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?
 
G

Guest

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.
 

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

Inserting carriage return in report field 3
CHR(13) not working for carriage return 4
Carriage Return in Report - Textbox 4
Carriage return in a text box in a textbox in report. 4
Carriage Return - HELPQ!! 1
Combine / Concatenate text and include a carraige return 2
Carriage Return or Line Feed 1
Carriage Returns in an Access report. 1

Top