Showing Leading Zeroes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dozer - 12 Feb 2004 16:27 GMT

Hi All:

My client would like to show leading zeroes in a numerical
field. I have the field set as an Integer, made the format
property Fixed and I have set the input mask to 00.

However, even though it requires 2 digit input (03) it
still only shows the single digit (3).

What do I have to do to make it stay as 03 and keep it a
number field?

Thanks.

Reply to this Message

Allen Browne - 12 Feb 2004 16:36 GMT

You placed the 00 in the Input Mask
Place it in the Format property of the field.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi All:
>
[quoted text clipped - 9 lines]
>
> Thanks.

Reply to this Message

Dozer - 12 Feb 2004 17:29 GMT

Absolutely Brilliant!!

Thanks Allen

>-----Original Message-----
>You placed the 00 in the Input Mask
[quoted text clipped - 15 lines]
>
>.

Reply to this Message