Line feeds in a report text box

  • Thread starter Thread starter Bill Reed via AccessMonster.com
  • Start date Start date
B

Bill Reed via AccessMonster.com

I have a problem with a report detail. There is a txt box that can (and
does) grow. In the same section I have 3 txtboxes 1 underneath the other.
When the offending txtbox grows, there is an unsightly space between the
1st and 2nd txtboxes down the line, on the same horizontal as the growing
txtbox. I have experimented moving the txtboxes around, but no matter what
I do, I end up with a space between 2 of the txtboxes when the other one
grows. I thought I might concatentate the 3 textboxes as in:

=[Designer] & chr(10) & chr(13) & [Checker] & chr(10) & chr(13) & [Stress]

Or by using VBCRLF in place of the Chr functions. But that doesn't work.
Any suggestions?
 
It has to be Chr(13) & Chr(10), not Chr(10) & Chr(13)

However, vbCrLf should have worked, so I'm wondering if I understand what
you're really complaining about...
 
I'm putting that code in the textbox itself. I don't know how to assign
that return value via VBA, so I put it in the source of the text box.
 
You cannot use the VBA constant vbCrLf in an Access control source.
You can only use chr(13) & chr(10) .... in that order.

=[Designer] & chr(13) & chr(10) & [Checker] & chr(13) & chr(10) & [Stress]

Fred
 
Just got back to this project. Thank you all, getting the chr()s in the
right order did the trick.

Bill
 
Back
Top