how can i limit number of digits entered in the text box?

[esi_1981]

Hi guys,

I have a text box, which requires a 8-digit number entry.
I want to warn the users that they are entering too much data for that field and reset the text in the text-box to the left 8 characters that were originally in there

also I want to create a query for the users that have an 8 digit phone number and a query for the users that their names start with 'A'

I appreciate any help/advice



cheers

[ssanfu]

I have a text box, which requires a 8-digit number entry.

One simple way is to go into design view of table. Select the text field and set the Field Size to 8. (Unless you need to do math on the number, this field should have a field type of "TEXT")

I want to create a query for the users that have an 8 digit phone number

Create the query, then in the criteria row under the phone number field, enter "IS NOT NULL" (without the quotes)

and a query for the users that their names start with 'A'

Create the query, then in the criteria row under the surname field , enter 'Like A*' (without the quotes)

[RuralGuy]

And here's another method, just to keep it interesting: http://allenbrowne.com/ser-34.html

[esi_1981]

One simple way is to go into design view of table. Select the text field and set the Field Size to 8. (Unless you need to do math on the number, this field should have a field type of "TEXT")

The type of the box can not be "TEXT" because as yo said I should do some math on it. how can I generate warning message when the violation occurred?

Thank you so much,
Cheers.

[esi_1981]

And here's another method, just to keep it interesting: http://allenbrowne.com/ser-34.html

Nice solution, Thank you. I want to try it now.

[RuralGuy]

Nice solution, Thank you. I want to try it now.

Have fun. Allen knows his stuff!