Force new line in control source of a report

[Widemonk]

I have a text box in my report that concatenates a name and phone number in
to one string.

=[contactname] & ", " & [contacttel]

However, when a short name is listed, the telephone prefix appears on the
same line, ie...

John Smith, 01234
567890

How can I force a new line to separate the two ??

Thanks

 

[John Spencer]

If you always want a new line then the following adds a carriage return and
line feed to the string to give you a new line.

=[ContactName] & Chr(13) & Chr(10) & [ContactTel]

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County