Zero fill form fields

[wmdavidwynn]

I want a quick-n-dirty method of filling char or numeric fields on a form with leading zeros. Can I do that without VBA?

 

[quest4]

Yes, input masks will probably do the trick for you, try using something like:
90.99\%;0;_
If you chage the 9 to 0 then that will force everything to print. Of course you will have to modify it to fit your needs.

 

[wmdavidwynn]

Can you direct me to a good document that explains what those input mask characters really do in the situation? The instructions within Access really stink and are not very helpful for troubleshooting.

 

[quest4]

Sure, Access Help, InputMasks.