Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / February 2004

Tip: Looking for answers? Try searching our database.

Car registration input mask

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
t0d - 12 Feb 2004 10:47 GMT
How do you create an input mask for a field which will have a ca
registration that will have two letters, then two numbers and the
three letters? For example, AB22 ABC

-----------------------------------------------
~~
~~
Tim Ferguson - 13 Feb 2004 15:40 GMT
> How do you create an input mask for a field which will have a car
> registration that will have two letters, then two numbers and then
> three letters? For example, AB22 ABC.

In my opinion, just don't. Input masks have serious compatibility problems
with any other Windows control in any other application that your users
will ever use. The trick to providing useful Windows UIs is to give them
things that they are used to, not new and nonstandard stuff. Remember that
the only job that an Input Mask does is to restrict the keystrokes that a
user can make -- it doesn't protect the data.

You might want to use a Validation Rule instead, or else (or as well as)
the BeforeUpdate event. The advantage of the latter is that you can correct
minor mistakes intelligently (upper case, removing unwanted spaces).
Finally, UK car registration codes are a great deal more structured than
you have suggested up there, as you probably know, so only a BeforeUpdate
event will be able to check it properly.

Hope that helps

Tim F
t0d - 21 Feb 2004 22:29 GMT
Beforeupdate event? Whats that? how do I do that

-----------------------------------------------
~~
~~
Tim Ferguson - 22 Feb 2004 18:46 GMT
> Beforeupdate event? Whats that? how do I do that?

Look up help for Events on Forms.

Tim F
t0d - 21 Feb 2004 22:29 GMT
Beforeupdate event? Whats that? how do I do that?

------------------------------------------------
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.