Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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

  2. #2
    Star Lounger
    Join Date
    Oct 2001
    Location
    Western Massachusetts, USA
    Posts
    99
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

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

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

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

    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.
    Charlotte

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

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

    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.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •