preventing plus(+) sign

if i have a tabel with a 1 to many relationship
and i open that table in tableview,there is a plus(+) sign at the left side
of the records
how can i prevent that plus sign from showing

Found it
once one knows that table view is called datasheet view its quete easy
in datasheet view-format-subdatasheet-remove
problem is now how to make the subdatasheet reapaire (get the plus(+) sign
back


"Loterken" wrote in message
...
if i have a tabel with a 1 to many relationship
and i open that table in tableview,there is a plus(+) sign at the left
side of the records
how can i prevent that plus sign from showing

Assuming that you are using Access 2007:

Open up the table in Design view.

Right click on the heading area and bring up the Properties.

Change the Subdatasheet name to [None].

Save the changes.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Loterken" wrote:

if i have a tabel with a 1 to many relationship
and i open that table in tableview,there is a plus(+) sign at the left side
of the records
how can i prevent that plus sign from showing


.

i use access 2003
but your tip did it,solved
thanks

"Loterken" wrote in message
...
if i have a tabel with a 1 to many relationship
and i open that table in tableview,there is a plus(+) sign at the left
side of the records
how can i prevent that plus sign from showing

l!l!:hn:!

"Loterken" a écrit dans le message de groupe de
discussion : ...
if i have a tabel with a 1 to many relationship
and i open that table in tableview,there is a plus(+) sign at the left
side of the records
how can i prevent that plus sign from showing