Querying fields with Zeros

[velcrowe]

I have a database where the primary key is a field for pass numbers. Many of the pass numbers begin with zeros (example: 0023456). I changed the table property for the pass numbers to text so the zeros would be recognized. However, I have a form based on a query to search this pass number field. How can I get the query to recognize the pass numbers that begin with zeros. When I put in any other number above zero, the pass number satisfies the query and the employee information pops up. Aside from AllowZeroLength and trying to format the text field, I cannot get the query to recognize the pass numbers that begin with zero. Please help

 

[velcrowe]

If I would like to enter 000555 in my query parameter box and it recognize the entire number. Can it be done. So far when I enter 555 it will give me 000555, but not when I enter 000555. The query shows no value. How can i get it to recognize the entire zero string.