Auto Number

[Simon]

When i have a auto number it come out like '8' how can i set it to come
out with zero first like '0008'

if not is there a way on a report i can make it put the '000' first


Thanks

 

[RoyVidar]

When i have a auto number it come out like '8' how can i set it to
come out with zero first like '0008'

if not is there a way on a report i can make it put the '000' first


Thanks

You can place 0000 in the format property, either of the field in the
table or on the control of the report.

Often you will see the recommandation that autonumbers stay hidden,
though ;-)

 

[Joseph Meehan]

When i have a auto number it come out like '8' how can i set it to
come out with zero first like '0008'

if not is there a way on a report i can make it put the '000' first


Thanks

You can use format to change the way it is displayed, but I suggest that
since autonumbers are not guaranteed to be consecutive and are designed for
only one thing, providing unique numbers, that you may not want to use
autonumber for any use that you are concerned with people seeing it.