Input masks

[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

 

[Duane Hookom]

Personally, I have never felt the need to use them.

 

[Klatuu]

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.

 

[John Spencer]

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

 

[Lars Brownies]

Thanks all for input and confirmation.
Lars

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