Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Evansville, Indiana, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Number Format for Form Field (Word 2003)

    We have created an invoice template with form fields. We set the number format for one of the fields to be currency and then protect and save the .dot. When we start an new .doc based on the invoice template, any number typed into that field is a plain number and not in the currency format. What are we doing wrong? Thank you for your time.

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

    Re: Number Format for Form Field (Word 2003)

    What happens if you unprotect a document in which the form field displays a plain number, and double click the form field? What format does it have?

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Evansville, Indiana, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Format for Form Field (Word 2003)

    Hans,

    When I double-click on the field in an unprotected sheet, I show the form field is formatted as currency ($#,##0.00;($#,##0.00)) but the number displays as a number only and no dollar sign.

    Trena

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

    Re: Number Format for Form Field (Word 2003)

    I cannot reproduce the problem. Could you attach a stripped down copy of the document? Remove all sensitive information from it.

  5. #5
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Format for Form Field (Word 2003)

    Once in a while I experienced similar problems with FormField formats. I think it's some form of corruption. The solution that always works for me is to remove that FormField, add a fresh one and set the correct name and settings again.

  6. #6
    Lounger
    Join Date
    Jan 2001
    Location
    Evansville, Indiana, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Format for Form Field (Word 2003)

    Hans,

    Thank you. I have attached the form. Please let me know what you find. Thanks a million for your time.

    Trena
    Attached Files Attached Files

  7. #7
    Lounger
    Join Date
    Jan 2001
    Location
    Evansville, Indiana, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Format for Form Field (Word 2003)

    Jan,

    Thank you for your reply. Unfortunately, it didn't work.

    Trena

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

    Re: Number Format for Form Field (Word 2003)

    Currency format has been set for only some of the form text boxes. You will have to set it for each form text box individually (or set up one the way you want, then copy/paste).

    The form text boxes that are set to currency format work OK for me, as far as I can tell. If it's different for you, please indicate exactly which one(s).

Posting Permissions

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