how to add hard returns in unbound field

T

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.
 
F

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.
Click to expand...

=[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.
 
Top