Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE

setting specific criteria for textbox

Copper Contributor

Hello everyone,

I am trying to set specific criteria for a textbox. The criteria that I am trying to set are as follows:

- Only input between 7 and 9 signs (numbers/text) should be possible.
- The input must always start with numbers.

The textbox for which I am trying to set this criteria will be used to enter an order number. The reason I am trying to set the criteria, is to make sure that no other data can be filled in the text box except for the Order number.

If someone knows how to set these criteria, that would be absolutely great! I am pretty new with Access and I tried many things, but unfortunately I can’t figure it out.

 

Kind regards,
Dimitri

1 Reply

@Dimitri1220 

 

Have you tried using Input Masks on the properties of the text box?