How do you zero fill in Access other than the format property?
I have a field in a table that needs to be 9 digits. Since the input may differ from 1-9 I need to left zero fill. When using the format property, the fill isnt saved from the form to the table. The field is a text field so as to not drop the zeros.
This is an easy question for an expert but an answer is needed badly so I will give extra points for this one..