You correct, you can't do it as I said. Sorry! But you can format an
autonumber, at least in ACC2003! You have to do it either in table design
view or in the control's property box. You simply enter six zeros!
Having said that, I agree that Autonumbers should never see the light of day!
As John Vinson says, they're unfit for human consumption! Auto-incrementing
numbers should be used for such things as account numbers, ID numbers, stc.
--
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com