Input masks

  • Thread starter Thread starter Lars Brownies
  • Start date Start date
L

Lars Brownies

I had to make changes to a inhereted database where almost every field in
all tables have input masks. I'm not used to using them as I don't like them
when entering data. For instance you see an underlying in the whole field.

I thought you'd use input masks only for fields like zipcode or phone
number, and in that case you're often restricting yourself because you can't
enter exceptions (for instance zipcodes from other countries).

Is it common practice to use that many input masks? What do you guys usually
do?

Thanks,
Lars
 
I'm with Duane on this. They are more trouble than they are worth. A better
practice is to use the Before Update event to validate the entry. To do
specific formatting, the After Update event is useful.
 
I seldom use input masks. On occasion they are useful to force correct entry,
but usually I find them to be a pain in the neck (or lower).

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Thanks all for input and confirmation.
Lars

John Spencer said:
I seldom use input masks. On occasion they are useful to force correct
entry, but usually I find them to be a pain in the neck (or lower).

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...
 
Back
Top