Line feeds in a report text box

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

 

[Douglas J. Steele]

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...

 

[Bill Reed via AccessMonster.com]

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.

 

[Douglas J. Steele]

So did changing it to Chr(13) & Chr(10) fix it?

 

[f g via AccessMonster.com]

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

 

[Bill Reed via AccessMonster.com]

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

Bill