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

Field Length for text box in form

P: n/a
Is there a way to set field length on an access form? I have a text
box that I want to make only one letter long(it stores a middle
initial).

Or is there a way to set up a validation rule that only allows one
character?

I am using a linked sql table and I can set the field length to 1 in
SQL however the error that appears is messy looking if you type in
something that is too long.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Certainly! The responsible property is called ValidationRule, appropriately.

You can also apply an input mask of "a" which allows just one character.
That way the limitation is visible. Users can handle limitations better
when they are informed beforehand.

td*******@yahoo.com wrote:
Is there a way to set field length on an access form? I have a text
box that I want to make only one letter long(it stores a middle
initial).

Or is there a way to set up a validation rule that only allows one
character?

I am using a linked sql table and I can set the field length to 1 in
SQL however the error that appears is messy looking if you type in
something that is too long.


--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.