[Kamran]

Hello,
I need to create a macro that will ensure that input into a text form field
is no higher than 99.9.

I've tried using the Maximum Length feature, but I'm unable to use that
properly with decimals because it won't automatically add a "0" decimal when
using the mask "##.0" and it accepts numbers higher than 99.9 if I use the
standard mask "#,##.0". Also, for example, it will turn "333" into "33.3" if
I don't manually type in the decimal.

So what I need is a field that will accept a "XX.X" format and reject
anything higher than that. Thanks in advance.

[Jay Freedman]

On Fri, 24 Oct 2008 14:17:01 -0700, Kamran
wrote:

Hello,
I need to create a macro that will ensure that input into a text form field
is no higher than 99.9.

I've tried using the Maximum Length feature, but I'm unable to use that
properly with decimals because it won't automatically add a "0" decimal when
using the mask "##.0" and it accepts numbers higher than 99.9 if I use the
standard mask "#,##.0". Also, for example, it will turn "333" into "33.3" if
I don't manually type in the decimal.

So what I need is a field that will accept a "XX.X" format and reject
anything higher than that. Thanks in advance.

See http://www.word.mvps.org/FAQs/TblsFl...ateFFields.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.