I am creating a table to hold account details, i wondered if it was possible to force the ID column (Autonumber) to have 5 digits (i.e. 00001, 00011, 00111 etc.).
I have tried using the format option, however have found that this only displays it as a five digit number and only uses a one...