How do I hide the subdatasheet indicator?

[Guest]

Hi

I have a form which contains a subform (displayed as a datasheet) which in
turn contains another subform that pops up. I do not wish to display this
last form as a sub-datasheet and more importantly do not wish for the expand
sub datasheet indicator to appear at all. Is there a way to hide the
subdatasheet expander?

Thanks in advance.

 

[Allen Browne]

Your subform is bound to a table.
Open that table in design view.
Then open the Properties box (View menu.)
Set the Subdatasheet Name property to:
[None]

As a side effect, your database can perform better (faster) after changing
your tables like this.

 

[Guest]

Your subform is bound to a table.
Open that table in design view.
Then open the Properties box (View menu.)
Set the Subdatasheet Name property to:
[None]

As a side effect, your database can perform better (faster) after changing
your tables like this.

Hi Allen
Alas no, all my tables have the Subdatasheet Name property set to [None]
(for the performance reason you stated).
If I remove the subform the subdatasheet expander disappears. Is there a
property of the subform that sets whether it can be displayed as a
subdatasheet?

 

[Allen Browne]

The Subdatasheet Height or Subdatasheet Expanded properties could make a
difference.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Your subform is bound to a table.
Open that table in design view.
Then open the Properties box (View menu.)
Set the Subdatasheet Name property to:
[None]

As a side effect, your database can perform better (faster) after
changing
your tables like this.

Hi Allen
Alas no, all my tables have the Subdatasheet Name property set to [None]
(for the performance reason you stated).
If I remove the subform the subdatasheet expander disappears. Is there a
property of the subform that sets whether it can be displayed as a
subdatasheet?