Carriage return

[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

 

[Duane Hookom]

Try both Chr(13) & Chr(10).

 

[Larry Linson]

Try both Chr(13) & Chr(10).

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]

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

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

Ack! Fumble Fingers. "constate" should read "constant".

 

[Jack Isaacs]

Many thanks to both of you - using both, in that order, did the trick (and I
would never have thought of it!)
Les