Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limit Character Entries In A Text Field?

Status
Not open for further replies.

HiBoo

Programmer
Jan 11, 2000
88
CA
I'm wondering how I can control or prevent a user from entering in a certain amount of text characters.&nbsp;&nbsp;<br><br>Example:<br><br>I've got a EMPLOYEE table with FName as an attribute with a size constraint of 20 characters.&nbsp;&nbsp;In my EMPLOYEE form i've got a txt box to enter the First Name of the Employee.&nbsp;&nbsp;I'd like to prevent the user from simply pressing a key repeatedly more than 20 times .... mmmmmmmmmmmmmmmmmmmmmmmmmmmmm ...<br>like that.&nbsp;&nbsp;Is there any way to make the txt box stop the user past 20 characters?<br><br>Is there code out there that I can use to access the Field Size Constraint of an attribute in a table so that I can write a function to limit the user from exceeding the maximum???<br><br>Thanks!!!
 
hope this is what you meant!<br><br>if you put in the textbox input mask type in <br>CCCCCCCCCCCCCCCCCCCC it will allow only one letter for each C but won't require entry<br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top