If you want to know how many characters are in the text box, use the Len function. If however, you want to know the maximum number of characters you can have in a text box, then it is 255. If you need more than 255 then you will need to change the field to a Memo field.
Hi GTI,
Sorry to have got the wrong end of the stick. Depends on whether the text box is bound or unbound. If bound, then you can limit the number of characters in the table. Go to the table design and set the field length to 2 If the text box is unbound, then you can use an input mask. The help file will give you format you require. Just type in Input Mask and look for Examples of Input Masks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.