Search code examples
formsms-accessms-office

Ho to create an textbox mask to allow only text on Office Access form


When building an Access form, you can create a textbox with a mask. There are masks ready to use like MM/DD/YYYY for dates or HH:MM:SS for complete hours.

How to create a mask to allow only text with any size?

Examples:

Allowed:
MARK
New York

Not allowed
November 20
5800

Thanks.


Solution

  • Set the property InputMask of the textbox to a large number of "?", like:

    ?????????????????????????????
    

    For other options, study the docs: TextBox.InputMask property (Access).