Access 2003 - Report field -Line feed & carriage return
Hello Everybody,
I created a report in Access 2003. One the fields contains phonenumbers. The phone numbers are stored in diif fields of db. I concatenated then in the above field using Properties->control source->Build
Code:
=[hPh1] & ', ' & [oPh1] & ', ' & [mob1]
The problem is the phone numbers need to be displayed one on each line. I used chr(10) & chr(13), all I get is two square boxes. I set the CanGrow and CanShrink to YES.
Can somebody help
DB: Access 2003
Report: Access 2003 :wave:
Re: Access 2003 - Report field -Line feed & carriage return
Is there no way to introduce a line feed & carriage return in report?
Re: Access 2003 - Report field -Line feed & carriage return
Quote:
I used chr(10) & chr(13),
The order of the CRLF characters is backwards. Try chr(13) & chr(10) instead.