setting specific criteria for textbox

%3CLINGO-SUB%20id%3D%22lingo-sub-1055658%22%20slang%3D%22en-US%22%3Esetting%20specific%20criteria%20for%20textbox%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055658%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20trying%20to%20set%20specific%20criteria%20for%20a%20textbox.%20The%20criteria%20that%20I%20am%20trying%20to%20set%20are%20as%20follows%3A%3CBR%20%2F%3E%3CBR%20%2F%3E-%20Only%20input%20between%207%20and%209%20signs%20(numbers%2Ftext)%20should%20be%20possible.%3CBR%20%2F%3E-%20The%20input%20must%20always%20start%20with%20numbers.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThe%20textbox%20for%20which%20I%20am%20trying%20to%20set%20this%20criteria%20will%20be%20used%20to%20enter%20an%20order%20number.%20The%20reason%20I%20am%20trying%20to%20set%20the%20criteria%2C%20is%20to%20make%20sure%20that%20no%20other%20data%20can%20be%20filled%20in%20the%20text%20box%20except%20for%20the%20Order%20number.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20someone%20knows%20how%20to%20set%20these%20criteria%2C%20that%20would%20be%20absolutely%20great!%20I%20am%20pretty%20new%20with%20Access%20and%20I%20tried%20many%20things%2C%20but%20unfortunately%20I%20can%E2%80%99t%20figure%20it%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2CDimitri%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1055658%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1065550%22%20slang%3D%22en-US%22%3ERe%3A%20setting%20specific%20criteria%20for%20textbox%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1065550%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416383%22%20target%3D%22_blank%22%3E%40Dimitri1220%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20tried%20using%20Input%20Masks%20on%20the%20properties%20of%20the%20text%20box%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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
Highlighted

@Dimitri1220 

 

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