Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting Underlying Data (2002)

    I'm sure this has been answered before but I can't find it.

    I have a field - phone number - formatted 123-456-7890. However, that data isn't stored in that format in my table. It displays correctly on my form.

    How do I insure that the table has it formatted too? I notice this when I export the data to Excel and some of the phone numbers are not formatted properly.

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Formatting Underlying Data (2002)

    There is probably an Input Mask for tjhis field that doesn't store the hyphens in the table. An Input Mask consists of three sections:
    - The first section is the code for the mask.
    - The second section is either 0 to store the characters you don't have to type, or 1 to leave those characters out of the stored value; if you omit it, 1 is assumed.
    - The third section is the character used to show where the user can enter data.

    If you set the middle section to 0, the hyphens will be stored for all values entered or modified from now on. It won't change the values already stored, however, so you'd have to start by running an update query to insert those hyphens.

    Another possibility is to set the number format for the telephone numbers in Excel; see Special in the list of categories in Format | Cells..., Number tab.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Underlying Data (2002)

    Hans, that took care of the problem. I didn't realize what the extra sections were for.

    THANK YOU!!!!

    Peggy

Posting Permissions

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