From: Loterken on
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


From: Loterken on
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" <loterken(a)pandora.be> wrote in message
news:u%23zwhjWuKHA.5008(a)TK2MSFTNGP05.phx.gbl...
> 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
>
>


From: Jerry Whittle on
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
>
>
> .
>
From: Loterken on
i use access 2003
but your tip did it,solved
thanks


From: De Jager on

"Loterken" <loterken(a)pandora.be> wrote in message
news:u%23zwhjWuKHA.5008(a)TK2MSFTNGP05.phx.gbl...
> 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
>
>