By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,626 Members | 1,929 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,626 IT Pros & Developers. It's quick & easy.

how can be set value length of text box in access form 2007

P: 3
I wan to set value length of text boxes in access form 2007. and send a massege
Jan 11 '15 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,240
Welcome to Nice to have another new poster.

Your question is not at all clear. Are you saying you want to enforce a maximum length for what gets entered into the texbox? And give a message if that length is exceeded? If that is what you want try using the validation properties in the data tab of the text box.

In validation rule, for Textbox1, if you want no more than 5 characters try
Expand|Select|Wrap|Line Numbers
  1. Len(Textbox1)<=5
and in the validation message enter the message you want to appear if more than 5 characters are entered.

Please let us know if that is what you meant, or clarify your question so we can help.

Jan 11 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.