Preventing Subdatasheet Symbol

[Dean]

I have a form with several subforms. If the users change from form view to
datasheet view, the '+' symbol shows up and clicking this displays the data
from one of the subforms. How can I hide the '+' symbol when in datasheet
view so that this functionality is not available. I'm using Access 2002.
TIA
Dean

 

[Dirk Goldgar]

I have a form with several subforms. If the users change from form
view to datasheet view, the '+' symbol shows up and clicking this
displays the data from one of the subforms. How can I hide the '+'
symbol when in datasheet view so that this functionality is not
available. I'm using Access 2002. TIA

For each such table, open the table in design view, bring up the
property sheet for the table (not any of the individual fields), and
change the Subdatasheet Name property to [None].

I think Allen Browne has posted some code to loop through all tables and
do this programmatically. You can probably find it by searching Google
Groups, if you want to do that.