[AccessD] Hide Autonumber

That works.  Thanks Gustav.

----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Sunday, August 01, 2004 6:04 PM
Subject: Re: [AccessD] Hide Autonumber


> 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
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>