Text Box formating question

[mrrrl]

I am using MS Access to access a SQL7 database. I am using a unbound text box that the user can enter a number in. The field in the SQL database is a [varchar] 5 NULL. How do I format the users input from the text box to match the field in the database so when I use it to query I get the correct record back. I need the users input to be “ 2” ,right justified with leading spaces, 5 characters total and not “2”.

I have tried input masks but they enter data left to right.

Thanks

 

[Zeroanarchy]

mrrrl try asking the same question in this forum you may get a quicker responce.

Microsoft: Access - General discussion

Zero Anarchy

 

[mrrrl]

Thanks I will.