Results 1 to 3 of 3
  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

    Print Partial Phone Number (Access 2000 (9.0.4402) SR-1)

    Print Partial Phone Number

    Using Access 2000 (9.0.4402) SR-1

    I have phone number defined as follows:

    StrPhone Text !(999

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Partial Phone Number (Access 2000 (9.0.4402) SR-1)

    Try this: Format(Right([PhoneNumber],7),"000-0000")

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

    Re: Print Partial Phone Number (Access 2000 (9.0.4402) SR-1)

    Is that an input mask for the table field or for a form control? Is the data actually saved with the additional characters or without? If the formatting is NOT saved, then it's easy to simply use the Right() function to return the value and the Format() function to apply the formatting you want.

    Format(Right(strPhone,7),"@@@-@@@@")

    If the formatting is saved, just use the Right function like this:

    Right(strPhone,8)
    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
  •