Number Field

[ren]

Hi all,

Every time I select a particular ID that is displayed automatically through a drop down list, it shows the correct ID format (e.g. 0001) but whenever the record is saved, the ID format will change to 1 only.

In the database, I've set the serial auto number for the ID to 0001 increment by 1 and on the layout, I've set the number format for the ID field to "General Number".

Does anyone know on how to fix this?

Thank you.....

Rgds,

ren

[MoonShadow]

Change your ID to text. It may not appear logical but, believe me, it's the only way to go. You can leave your auto-enter serial to 0001; no problem there. But because it will be text, the leading zeros will remain.

[Lee Smith]

change the format of your field to text.

[Lee Smith]

It's a tie, except you win.

[ren]

Thank you guys, an ID text field solved my problem for now:)