Carriage return

  • Thread starter Thread starter Leslie Isaacs
  • Start date Start date
L

Leslie Isaacs

Hello All

I have a report with a memo field that has been built up with a looping
append query. All works well except that where wanted to force new lines I
added Chr(13), so I have an expression like the following:

[next_item]&Chr(13)

but this prints out as a small vertical line instead of forcing the new
line. I have tried Chr(10) but this was no better.

How can I force a new line to be inserted after the specified text?

Hope someone can help

Many thanks
Leslie Isaacs
 
Try both Chr(13) & Chr(10).
Click to expand...

In that order, because the reverse won't work.

In code in a module, you can use the intrinsic constate vbCrLf.

Larry Linson
Microsoft Access MVP
 
Larry Linson said:
In that order, because the reverse won't work.

In code in a module, you can use the intrinsic constate vbCrLf.
Click to expand...

Ack! Fumble Fingers. "constate" should read "constant".
 
Many thanks to both of you - using both, in that order, did the trick (and I
would never have thought of it!)
Les
 
Back
Top