You can use the SubdatasheetExpanded property to specify or determine the saved state of all subdatasheets within a table or query.
Note The SubdatasheetExpanded property applies only to tables and queries within a Microsoft Access database (.mdb).
Setting
The SubdatasheetExpanded property uses the following settings.
Setting | Visual Basic | Description |
---|---|---|
Yes | True (–1) | The saved state of all subdatasheets in the table is expanded. |
No | False (0) | (Default) The saved state of all subdatasheets in the table is closed. |
The easiest way to set the SubdatasheetExpanded property is by using a table's property sheet. You can set this property by using Visual Basic.
To set the SubdatasheetExpanded property by using Visual Basic, you must first either:
Remarks
The value of the SubdatasheetExpanded property is displayed in the Table Properties property sheet.
The SubdatasheetExpanded and SubdatasheetHeight properties take effect on the subform control when the form is in datasheet view.