Linefeed in Report textbox 1

[Muttley]

Hi

How do I insert a linefeed/carriage return character in a textbox on a report? I've tried using the following syntax, which doesn't seem to work:

= [address1] & Chr(13) & [address2]

also:

= [address1] & vbCrLf & [address2]

Any tips?

TIA

Muttley

 

[JoeMiller]

Try this:

=[Address1] & Chr(13) & Chr(10) & [Address2]

HTH Joe Miller
joe.miller@flotech.net

 

[Muttley]

Joe

Thanks a million, that worked great!

Muttley