Input Mask to Zero Fill Leading Blanks 1

[OB1too]

Trying to create a Text Box on a Form which is input into a Query. The field I'm "searching" on in the Table is Text , e.g. 0000000123.
I want to be able to type 123 into the Form Control and that to be converted to 0000000123 for the Query. Any help would be very much appreciated.
Thanks

 

[JerryDennison]

If you're using the form control as criteria for a field in the query it probably looks something like the following:

Forms!FormName!ControlName

change it to:

Format(Forms!FormName!ControlName, "0000000000&quot

 

[JerryDennison]

Another way is this:

Like "*" & Forms!FormName!ControlName

 

[OB1too]

Brilliant!....Thanks for that...the first one did the trick.

 

[JerryDennison]

You're welcome.