Initial Autonumber dispaly.

[MC]

How do I get rid of the initial text "Autonumber" in the autonumber field of
a form when selecting a new record. When I start a new record I would like
this to be blank or the number "0".

Thanks in advance

MC

 

[GVaught]

I don't think you can change this. This has been written into the
application program. Technically, you should not be showing this value to
the user any way as it is used only to create a primary key. Do not expect
the autonumber to keep exact numerical sequence. Once you delete a record
that records number can't be recovered, thus showing gaps. Set the
autonumber to invisible through its properties.

 

[Van T. Dinh]

1. The only purpose of an AutoNumber Field is to provide uniqueness to each
Record in the Table. The actual values allocated can become random and even
negative (using replication). Thus, I use AutoNumber Fields often but my
users NEVER see the values of the AutoNumber Fields. If the values have
some meaning to the users, you should NOT use AutoNumber.

2. If you really want, use code to change the ForeColor of the Control
bound to the AutoNumber Field to be the same as the BackColor for new
Record. This way, the word "AutoNumber" is still there but the users can't
see it. Of course, if you want to show the value, you will have to use code
to change the ForeColor back to a visible color.

 

[Rick Brandt]

How do I get rid of the initial text "Autonumber" in the autonumber field of
a form when selecting a new record. When I start a new record I would like
this to be blank or the number "0".

Use a TextBox with a ControlSource of ...

=[AutoNumberField]+0