S
srctr
I am combining 2 phone numbers into one field on a report.
=[HomePhone] & Chr(13)+Chr(10)+[MobilePhone]
This works but the second number loses its format and it show like this
800-555-1212
8005551212
How do I fix?
=[HomePhone] & Chr(13)+Chr(10)+[MobilePhone]
This works but the second number loses its format and it show like this
800-555-1212
8005551212
How do I fix?