Reply
 
Thread Tools Display Modes
  #1   Report Post  
UnclePaul
 
Posts: n/a
Default Enforcement of Form Field Type

I've defined a text form field with a 'type' of 'Number'. However I can
enter any kind of garbage (text, punctuation, numbers, etc) and it is
accepted in the field if I just enter the data and then simply click
elsewhere in the form - that is, I don't hit the Tab key to advance to the
next item. (If I hit Tab, the garbage gets converted to a zero.) How can I
prevent non-numeric data from being entered into the form's supposedly
numeric fields by users who don't use the Tab key? (Word 2003)
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

Use the IsNumeric() function to test the .Result of the formfield in a macro
that runs on exit from the field.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"UnclePaul" wrote in message
...
I've defined a text form field with a 'type' of 'Number'. However I can
enter any kind of garbage (text, punctuation, numbers, etc) and it is
accepted in the field if I just enter the data and then simply click
elsewhere in the form - that is, I don't hit the Tab key to advance to the
next item. (If I hit Tab, the garbage gets converted to a zero.) How can I
prevent non-numeric data from being entered into the form's supposedly
numeric fields by users who don't use the Tab key? (Word 2003)



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Compile/Analyze Word Form Field data from multiple forms? Dave Peterson Microsoft Word Help 2 July 14th 05 02:54 AM
SEQ Field not in cross-reference reference type pull-down menu The Josh Microsoft Word Help 5 May 25th 05 02:27 PM
using a form field in an email letter Jonathan Parminter Microsoft Word Help 4 February 4th 05 01:51 AM
Automated form field population Lou Greuling Microsoft Word Help 2 February 2nd 05 11:35 PM
form and form field formatting stacyo Microsoft Word Help 4 December 8th 04 04:52 PM


All times are GMT +1. The time now is 08:32 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"