10 characters only

  • Thread starter Thread starter Mazza
  • Start date Start date
M

Mazza

Hi guys,
I have a field on a form in a database that has many relational tables. My
problem is that originally I was asked to make a certain field 20 characters
long now I am required to ensure that the end users only enter 10
characters. I know I can change the required amount of characters at the
table level but this requires me to take away all the relationships change
the field and put them back again, I don't want to do this because I know
later on they will change it again. So, is there a way to restrict the end
user to only enter 10 characters.

Thanks in advance

Mazza T
 
You could use an Input Mask on the control in the form. This is on the Data
tab of the control's Properties. An input mask of
CCCCCCCCCC
will allow any number of characters or spaces with a maximum of 10. If you
want to restrict it to just alpha characters, that can be done to.
 
Back
Top