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:
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: