Prevent Autonumber from Appearing in Subform

[Fatz]

I have a table that is an autonumber field. This table appears as a
subform in another form. I want the ID# to show in the subform...but I
don't want the (Autonumber) to show at the bottom of the subform.

Is there anyway to prevent the last field in my table that has the ID
(Autonumber) from appearing in the sub?

Thanks!
Chris

[Paradigm]

Why not just set its visible property to false?

"Fatz" <cc******@ibtco.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I have a table that is an autonumber field. This table appears as a
subform in another form. I want the ID# to show in the subform...but I
don't want the (Autonumber) to show at the bottom of the subform.

Is there anyway to prevent the last field in my table that has the ID
(Autonumber) from appearing in the sub?

Thanks!
Chris

[jv]

If you set the visible property to false, it would make all ID# on a
continuous form invisible. Try experimenting with conditional
formating. Conditional formating effects each record individually.
You can specify that if the Name field is null then change the
forecolor of the ID# field to white ... etc..

[Rick Brandt]

Fatz wrote:

I have a table that is an autonumber field. This table appears as a
subform in another form. I want the ID# to show in the subform...but
I don't want the (Autonumber) to show at the bottom of the subform.

Is there anyway to prevent the last field in my table that has the ID
(Autonumber) from appearing in the sub?

Thanks!
Chris

Change the ControlSource for that control.

Instead of...
[FieldName]

use...
=[FieldName]

Make sure the name of the control is not the same as the name of the field.

[Jerry Porter]

Chris,

If you include your ID field in your subform as a calculated field
(instead of linking directly to the table field), you'll see the ID's
of the exiting records, but "(AutoNumber)" won't show in the New Record
row. In the properties of the field in the subform, change the Name
property to something else, for example txtID. Then set the Control
Source to:
=[ID]

Jerry

[jv]

Good trick! Thanks.

[Fatz]

Jerry-

Thanks for the help!

Go Raiders...

Chris

[Trevor Best]

Fatz wrote:

I have a table that is an autonumber field. This table appears as a
subform in another form. I want the ID# to show in the subform...but I
don't want the (Autonumber) to show at the bottom of the subform.

Is there anyway to prevent the last field in my table that has the ID
(Autonumber) from appearing in the sub?

Why are you even displaying an autonumber field? If users can see it
then they start asking stupid questions like, "why doesn't it start from
1 on this record?", "why are there gaps in the numbering?". They try to
make sense and meaning of this field when it's sole purpose is to give a
unique ID to a record, no more and no less. It means a lot more to a
computer than a human. Humans shouldn't be alowed to see such things.

--
This sig left intentionally blank