{"id":182,"date":"2014-06-25T00:34:22","date_gmt":"2014-06-25T04:34:22","guid":{"rendered":"http:\/\/access-diva.com\/blog\/?p=182"},"modified":"2016-07-08T21:00:35","modified_gmt":"2016-07-09T01:00:35","slug":"expand-subdatasheets","status":"publish","type":"post","link":"https:\/\/access-diva.com\/blog\/?p=182","title":{"rendered":"Expand SubDatasheets"},"content":{"rendered":"

Okay, so we all know I recommend turning off the SubDatasheet<\/a>\u00a0but I can see by the Forums they are still quite popular.\u00a0 For those of you that are still using them…\"SubDatasheetClosed\"<\/p>\n

When you first open your Main Form\/Subform (Datasheet View) it opens closed (Little plus signs).\u00a0 This is often quite annoying to Users as they are the ones that have to click all those little plus signs to see the data in the SubDatasheet.\u00a0 So, let’s fix that!<\/p>\n

 <\/p>\n

In the On_Load event of the Main Form put…<\/p>\n

Private Sub Form_Load()<\/p>\n

\r\n     With Forms("YourMainFormName")\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 .SubdatasheetExpanded = True\r\n     End With\r\n<\/pre>\n
End Sub<\/p>\n
Then the next time you open the Form…\"SubDatasheetExpanded\"\u00a0 Enjoy!<\/p>\n
 <\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Okay, so we all know I recommend turning off the SubDatasheet but I can see by the Forums they are still quite popular. For those of you that are still using them…<\/p>\n
When you first open your Main Form\/Subform (Datasheet View) it opens closed (Little plus signs). This is often quite annoying to Users as […]<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71,67,73,28],"tags":[68,22],"class_list":["post-182","post","type-post","status-publish","format-standard","hentry","category-forms","category-subdatasheets","category-subforms","category-tables","tag-subdatasheet","tag-subforms","odd"],"_links":{"self":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=182"}],"version-history":[{"count":10,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/182\/revisions"}],"predecessor-version":[{"id":381,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/182\/revisions\/381"}],"wp:attachment":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}