• Formatting Underlying Data (2002)

    Author
    Topic
    #414514

    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!

    Viewing 2 reply threads
    Author
    Replies
    • #921692

      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.

    • #921693

      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.

    • #921716

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

      THANK YOU!!!!

      Peggy

    Viewing 2 reply threads
    Reply To: Formatting Underlying Data (2002)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: