Zeros inserted as placeholders

[goaksmith]

I want a number field in my table to be 4 digits. I have set up an input mask. 0000 This is working fine. When someone puts in 766 it tells gives them the warning message that there are not enough digits. My question is: Is there a way to make the number put a default 0 in front if there is a 3 digit number? For example, if someone uses the number above of 766 it will change it to 0766. Or if they put in 38 it will put in 0038?

Thanks in advance for your help.

Gretchen

 

[fpendino]

See if this link helps. There are a couple options depending on what you are trying to do.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=53867

 

[Rob.Mills]

Try this on the textbox's beforeupdate

Format([Textbox],"0000")