Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compile/Analyze Word Form Field data from multiple forms? | Microsoft Word Help | |||
SEQ Field not in cross-reference reference type pull-down menu | Microsoft Word Help | |||
using a form field in an email letter | Microsoft Word Help | |||
Automated form field population | Microsoft Word Help | |||
form and form field formatting | Microsoft Word Help |