Restrict number of character in Text Box

[Robin]

Hi

Can anyone help. How to restrict the number of character enter into the Text
Box. The Text Box is not linked to anything, just a normal Text Box.


Regards
Robin

 

[David Straker]

Robin,

An Input Mask of CCCCCCC, for example, should restrict the number of
characters to a maximum of 7.

hth,
David Straker

 

[Robin]

However I need to display what the user type in the Text Box. Is there any
other way. My purpose is to restrict user entering not more than 5 character
and user can see what they type.

 

[Van T. Dinh]

Don't get confused between the InputMask and the Formatting String.
InputMask is used to control how data is entered. Formatting is used to
control how data is display. They are 2 distinct Properties.

Set the InputMask of your TextBox to "CCCCC".

See Access Help for InputMask Property and Format Property.

 

[Robin]

Thank you very much Van T. Dinh.

Regards
Steve

Don't get confused between the InputMask and the Formatting String.
InputMask is used to control how data is entered. Formatting is used to
control how data is display. They are 2 distinct Properties.

Set the InputMask of your TextBox to "CCCCC".

See Access Help for InputMask Property and Format Property.