No Area Code Telephone Format? (A2k (9.0.4402) SR-1)

Topic

New Reply

No Area Code Telephone Format?

A2k (9.0.4402) SR-1

I have a telephone stored as (123) 456-7890.

What is the proper syntax in a report control to print 456-7890

Reply | Quote

Replies

Have you tried
Right([TelephoneNumberField],8)
Paul

Reply | Quote

Or, if your field can include an extension, Trim(Mid([TelephoneNumberField],4)), which says, start at the 4th position and give me everything from there to the end of the field and trim off any leading or trailing spaces. Of course, that assumes you will *always* have something in the first 3 positions.

Reply | Quote

I forgot to mention that I was assuming the formatting was NOT saved with the phone number. If it is, then you have to start at position 6 instead of 4.

Reply | Quote