Results 1 to 13 of 13
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Location
    Meriden, CT
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Number format in text form field (Word 97 SR-2)

    I need help with the behavior of number formatting in a text form field: In Text Form Field Options, I've selected Type: Number and Number format: 0.00%. User types "6" and expects to see "6.00%" upon advancing to the next field, but instead sees "600.00%". User types "6.00" and still gets "600.00%". Only if the user appends the percent sign will he see the proper number. I encountered this problem when converting a Word 6/95 form to Word 97, then tried from scratch in Word 97 and got the same results. Can anyone provide insight, perhaps a fix? Thanks.

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Number format in text form field (Word 97 SR-2)

    Sorry to say, the problem is the same in Word 2000 - this does seem like a bug. You might want to report this to MS by going <A target="_blank" HREF=http://support.microsoft.com/support/feedback/>here</A>.

    Gary

  3. #3
    Star Lounger
    Join Date
    Jul 2001
    Location
    Perth, Western Australia, Australia
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number format in text form field (Word 97 SR-2)

    I am afraid nothing has changed in Word 2002 as far as this behaviour is concerned.

    Still getting exactly the same thing occurring. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Cheers,

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Stuttgart, Baden-W, Germany
    Posts
    931
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number format in text form field (Word 97 SR-2)

    Probably MS considers this a feature, not a bug. In a sense, 600%=6.
    I don't know much about forms, but perhaps you could put the percent sign outside of the text box?

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>Klaus

  5. #5
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Number format in text form field (Word 97 SR-2)

    You're probably right that that is the way it's intended to work (now that you point it out): express the number typed as a percentage, in relation to 1.00.
    I tried typing 2.5 and got 250.00% - not exactly intuitive (nor necessarily useful!). This thread is good indication that most folks would expect that number format to behave otherwise.

    The "%" put just after the text form field does work fine though, in conjunction with the number format set to "0.00".

    Gary

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Number format in text form field (Word 97 SR-2)

    When you say a text form field, what exactly do you mean? The reason I ask is that when you type in a format in a form field to get a number displayed in a certain way, you should use #s to indicate where numbers will go - 0s will be added to the number; ie "#.#0%" will make 6% into 6.00%, but "0.00%" will return 60.00% or something similar.

    However, the phrasing you use seems to indicate that you chose an option rather than typed the format yourself ... ?
    Beryl M


  7. #7
    5 Star Lounger
    Join Date
    May 2001
    Location
    Stuttgart, Baden-W, Germany
    Posts
    931
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number format in text form field (Word 97 SR-2)

    Hi Beryl,

    Can't say that I fully grok the online help on the topic, but it seems to say that zeros are inserted for "0" and spaces are inserted for "#", so 0.00 seems fine.

    I've found another way to work around the problem, but it is a bit far-fetched: Use "Arial Unicode MS" as the font for the form, and handcraft the percent sign % with superscripted zero + fraction slash + subscripted zero. Since Word doesn't recognize this as %, 6 isn't changed to 600 any more.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>Klaus

  8. #8
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Number format in text form field (Word 97 SR-2)

    Hmmm. Could you post the actual doc (or the field code text involved)? It looks as if there is something else affecting the field result ...
    Beryl M


  9. #9
    Star Lounger
    Join Date
    Jul 2001
    Location
    Perth, Western Australia, Australia
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number format in text form field (Word 97 SR-2)

    Spot on Klaus, nice catch <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>. Obviously didn't have the thinking cap on very well when I was looking at this last time.

    On reflection, quite a few programs actually consider percentage to be as a portion of 1. Therefore 0.5 is considered to relate to 50%.

    Well done. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  10. #10
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Number format in text form field (Word 97 SR-2)

    Hi Beryl,

    When I set the text form field's number format to "#.#0%" and then type "6%" in the form field (and tab out of the field), I get "6.", not "6.00%".
    And if I try typing just "6", I get ".6%".

    What dbevins was looking for was a way for the user to type "6" and see "6.00%" in the form field - there doesn't seem to be any way to do that.
    Klaus' suggestion to use a "0.00" number format and put the "%" immediately after the form field seems the way to go.

    Gary

  11. #11
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Number format in text form field (Word 97 SR-2)

    If Klaus is right, and Word sees 6 as 600%, then couldn't you make your field
    { = {fillin "fillin number" } / 100 } ie. a mathematical formula?

    Just a thought <img src=/S/question.gif border=0 alt=question width=15 height=15>
    Beryl M


  12. #12
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number format in text form field (Word 97 SR-2)

    Hi Gary:

    I agree it's a bug. If you change the last two zeros to, say 5s, it works. i.e. 0.55% will let you type "9" & end up with 9.55%. However, 0.00% gets you 900.00%.

    You could use "#.00%" & then always type 3 numbers, but it's still a bug.

  13. #13
    5 Star Lounger
    Join Date
    May 2001
    Location
    Stuttgart, Baden-W, Germany
    Posts
    931
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number format in text form field (Word 97 SR-2)

    The MS programmers sure were too smart by half when implementing that ...

    Appended my solution, for which you'd need "Arial Unicode MS".

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>Klaus
    Attached Files Attached Files

Posting Permissions

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