Use Input Mask to autofill zeros in Client ID field
Posted on 2003-12-02
I am wondering if I can use an input mask to achive the following:
I have a client ID field in a Customers table in my database.
The Client ID is of the following form(all ID's have to be 10 chars long for uniformity):
03 is the year and then a literal forward slash separates year part from unique number part which must be 7 digits filled left with zeroes.
So with the above example in mind I would like to set up an input mask so all the user has to tap on the keyboard is 0 3 / 1 2 3
and what is displayed in field and saved is 03/0000123
i.e. the system automatically left fills the 4 zeroes before 123 to make sure the Clients ID total length is 10 characters
Is this possible using Input Mask