how to add hard returns in unbound field

[TracyG]

How do I add hard returns to an unbound field? I have a field that looks
like a mailing label that is a combination of several fields and I need to
be able to add hard returns rather than just spaces between each field.

 

[fredg]

How do I add hard returns to an unbound field? I have a field that looks
like a mailing label that is a combination of several fields and I need to
be able to add hard returns rather than just spaces between each field.

=[FieldA] & chr(13) & chr(10) & [FieldB] & chr(13) & chr(10 & etc.

Note. You must use both chr(13) & chr(10) in that order.

In VBA you can use either vbNewLine or vbCrLf as well.