Hello,
I am trying to limit the amount of characters that can be entered into a text box on a data access page in ms access. Currently it will allow the user to enter as many characters as they want then it truncates it to 255 when it saves it.
I would like to limit it to 255 so it doesnt allow them to enter more than 255 as there typing. Now it just keeps droping down to a new line every time it reached the end of the box.
I am aware that if you set the field to memo instead of text there is 64,000 character limit.
Thanks, in advance
-Rhino
I would like to refrain from that tough. - Dont want to bog down the database.
I am trying to limit the amount of characters that can be entered into a text box on a data access page in ms access. Currently it will allow the user to enter as many characters as they want then it truncates it to 255 when it saves it.
I would like to limit it to 255 so it doesnt allow them to enter more than 255 as there typing. Now it just keeps droping down to a new line every time it reached the end of the box.
I am aware that if you set the field to memo instead of text there is 64,000 character limit.
Thanks, in advance
-Rhino
I would like to refrain from that tough. - Dont want to bog down the database.