Input Mask in tables

[Lindyloo]

My input mask sits in my Primary Key field as LLL000 (3 letters and 3
numbers) if I key in anything different to this it stop it! Fine! but if I
import raw text data into the table then the input mask does not seem to work
and allows incorrect data to be imported into the table e.g. (2 letters 4
numbers). Can anyone help????

 

[John Spencer]

Input masks only work when typing data into a field.

You could try a validation rule and see if that works to stop the problem
Like "[a-z][a-z][a-z][0-9][0-9][0-9]" OR is Null

If strictly Access + Jet you can use
Like "[a-z][a-z][a-z]###" OR is Null


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[r_ghendrix]

I cant help with yer problem but I like yer name...