Today's guest blogger is Pavlo Pedan of ARGO Business Corp. He has 15 years of experience with Access and has a great site of tips at If you have a form that contains subdatasheets,
microsoft Office 2010 Activation, you can use the following VBA command to expand all of them: Forms,
Office 2007 Professional![FormName],
Microsoft Office 2007![SubFormName].Form.SubdatasheetExpanded = True However,
Microsoft Office 2007 Ultimate, we often want only some of the subdatasheets to be expanded,
Microsoft Office 2010 Professional Plus, based on
some criteria (for example - expand only if subdatasheets contain data.) Watch a short video demo and download a demo database from this page. Make sure you have added a reference to the "Accessibility" library (%windir%\system32\oleacc.dll). This has been tested on Access 2007. Send your Power Tips to Mike and Chris at accpower@microsoft.com. <div