PDA

Click to See Complete Forum and Search --> : Access 2003 - Report field -Line feed & carriage return


VBFnewcomer
Apr 21st, 2007, 03:19 AM
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
=[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:

VBFnewcomer
Apr 23rd, 2007, 04:57 AM
Is there no way to introduce a line feed & carriage return in report?

brucevde
Apr 26th, 2007, 01:14 PM
I used chr(10) & chr(13),

The order of the CRLF characters is backwards. Try chr(13) & chr(10) instead.