So I'm just getting back into using Access after a few years off, and now I'm racking my brain on this input mask. The field is for a member number that can be up to 7 digits but could be only 5. I'm using the following mask currently.

!99\-99\-99\-9;;_

So if I enter a member number of 1234567, it displays as:

12-34-56-7

However, if I enter a 5 digit member number of 12345, I get:

-12-34-5

I don't like how it displays in reports, so I'd like the mask to add in leading 0's so a 5 digit member number would show as:

00-12-34-5

Can anyone tell me what I'm missing in my mask, or if this is even possible? Thanks. :)

Chris

you might want to consider putting a mask in with 7 0's, then changing it to the format you want at other object levels. that might be easier. just a suggestion....