[AccessD] Hide Autonumber

Gustav Brock gustav at cactus.dk
Sun Aug 1 05:04:04 CDT 2004


Hi Stephen

> Does someone know how to format an autonumber field so that the text
> (autonumber) is not visible?

1. Rename the textbox with the Autonumber to something else than the
ID field, say txtID.

2. Adjust the ControlSource of txtID to the an expression with the ID
field:

  =[ID]

3. Set the format of txtID to Number.

Now txtID is "true Null" when Autonumber is Null.

/gustav




More information about the AccessD mailing list