Limit Number of Characters in Text Box

  • Thread starter Thread starter Jonathan Mulder
  • Start date Start date
J

Jonathan Mulder

Is there a text box property that would limit the
number of characters in a text box?
I have an unbound textbox that the user puts string
data into and then I INSERT that into a table record. If
the length of the string data exceeds the field length, I
get an error message.
Would it be something in the "Input Mask" property of
the textbox?
Or should I dim my string variable as a certain length
like:
Dim strTextBoxVariable as String * 60

Thanks for any helpful advice!
Jonathan Mulder
Red Bluff, CA
 
Is there a text box property that would limit the
number of characters in a text box?
I have an unbound textbox that the user puts string
data into and then I INSERT that into a table record. If
the length of the string data exceeds the field length, I
get an error message.
Would it be something in the "Input Mask" property of
the textbox?
Or should I dim my string variable as a certain length
like:
Dim strTextBoxVariable as String * 60

Thanks for any helpful advice!
Jonathan Mulder
Red Bluff, CA
Click to expand...

Controls have a validation rule property:

Len([ControlName]) <= 20
Also enter a friendly message in the validation text property.
 
Back
Top