How to limit the number characters typed in a text box on a ms acc

[Zadi Friedrich]

How everyone,
I need know how in ms access 2000 I can limit the number of character type
in a text box on a form. Say I want to limit the end user to be able to type
only 30 characters in a text box, as ms access unlike visual basic doesn't
offer this capability for its text box control, how can I achieve that?
Thanks

 

[Klatuu]

Use the Input Mask property of the text box. What you put in it will depend
on what characters are allowed. If you want to allow all characters
including space, then 30 Cs strung together:
CCCCCCCCCCCCCCCCCCCCCCCCCCCCCC

 

[Rob Oldfield]

Try this:

http://allenbrowne.com/ser-34.html

 

[Albert D.Kallal]

How everyone,
I need know how in ms access 2000 I can limit the number of character type
in a text box on a form. Say I want to limit the end user to be able to
type
only 30 characters in a text box, as ms access unlike visual basic doesn't
offer this capability for its text box control, how can I achieve that?
Thanks

If you are talking about a bound field, then just set the max size of the
field in the table design..and it will be limited for you.

And, as the other post mentioned, if you are using a un-bound text box..then
use a input mask of "CCCCCCC"