I am sure there is a simple answer.
I have a database that where I am trying to setup a security login
based on employee number.
Employee number is a 5 character numeric field. The databse has a sql
odbc link into the HR system to pull the emp number, emp name, and a
few other key fields. Because of the way the sql/odbc link is - this
field is a text field
Example emp numbers are:
00063
01222
On the login form, I have an unbound text box.
I've put an input mask of "00000" and default value of 0
I would like to make it so that the data entry starts from the right
side of the box. In otherwords, I would like to make it so that if the
person with employee number 63 goes to login, he only needs to type in
63 and not 00063. I would like the field to automatically add the
preceeding zeros if necessary.