Using Input Masks 1

[s0ccerdude]

I'm trying to use the input mask feature in a query to display a field of numbers in a four digit format. For example I want:
1 to be 0001
42 to be 0042
159 to be 0159, etc.

When I try to use "0" as the placeholder when creating a new input mask, I get:

1000 when I want 0001
4200 when I want 0042
1590 when I want 0159, etc.

Can someone explain how to use this feature?

 

[GoDawgs]

Try the Right function...like this:

Right("0000" & [yourfieldname],4)

Hope that helps.

Kevin

 

[s0ccerdude]

Thanks GoDawgs (Kevin)!

I used the function just as you suggested as an expression in a query. Got the desired results!