Concat with Return

[Guest]

I want to concat 2 Fields together and have a return between them

is field 1 & new line & field2

What is the correct format

Thanks

 

[Duane Hookom]

Try:
[FieldA] & Chr(13) & Chr(10) & [FieldB]

 

[SusanV]

Put & vbCrLf & between the fields you are concatting.

 

[Duane Hookom]

vbCrLf works well in code but not outside of code.

 

[SusanV]

Never occurred to me this was outside code...
Sorry for any confusion!

SusanV

 

[Duane Hookom]

This is a modules News Group so the question could have involved code. You
never know and when you think you know and make an assumption, you are often
wrong. 'been there many times.

 

[SusanV]

Excellent point!

This is a modules News Group so the question could have involved code. You
never know and when you think you know and make an assumption, you are
often wrong. 'been there many times.