Hi, Daniel.
The "plus" sign you see in the left-most column of the datasheet is to allow
users to view the related records from the related table. This feature was
introduced in Access 2K and has been causing annoyances ever since, most
notably performance issues with linked tables.
As Lynn advised you, one can't get rid of the "plus" signs while in
Datasheet View. However, one can disable the feature from the table's
Design View. Open the table in Design View and right-click in the upper
pane or on the title bar. Select "Properties" in the pop-up menu to open
the Table Properties dialog window. Select the "Subdatasheet Name" combo
box and change [Auto] to [None]. Save the table, then close the Table
Properties dialog window. Open the table in Datasheet View and you'll see
that the "plus" signs are gone.
I'll post a link later for the VBA code to remove this default property from
all tables so that you don't have to do this manually if you have more than
one table that needs to be changed.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
