{"id":1052,"date":"2015-12-19T19:14:25","date_gmt":"2015-12-20T00:14:25","guid":{"rendered":"http:\/\/regina-whipp.com\/blog\/?p=1052"},"modified":"2016-01-01T19:29:29","modified_gmt":"2016-01-02T00:29:29","slug":"controlling-scrollbars-in-subforms","status":"publish","type":"post","link":"https:\/\/regina-whipp.com\/blog\/?p=1052","title":{"rendered":"Controlling Scrollbars in Subforms…"},"content":{"rendered":"

Subforms are a little peculiar when used as Continuous Forms\u2026 when the Subform produces 3 records which, in this example, calls for the Scrollbar and you then switch, from the Main Form, and you only have two records or less showing you have this shadow area where the Scrollbar used to be (Figure2)\u2026 slightly annoying and not very nice looking on your Form.<\/p>\n

\"\"<\/span><\/p>\n

To avoid this put the below in the On_Current event of the Subform\u2026<\/p>\n

Note: In this example the Subform is sized to allow three records to show.\u00a0 If you have adjusted to show more (or less) records then adjust the RecordCount accordingly.<\/em><\/p>\n

\r\nIf Me.RecordsetClone.RecordCount >\u00a01 Then\r\n   Me.ScrollBars = 2\r\nElse\r\n   Me.ScrollBars = 0\r\nEnd If\r\n<\/pre>\n
Form.ScrollBars Property<\/strong><\/p>\n\n\n\n\n\n\n\n
Setting<\/strong><\/td>\nVisual Basic<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
Neither (forms) None (text boxes)<\/td>\n0<\/td>\n(Default for text boxes) No scroll bars appear on the form or text box.<\/td>\n<\/tr>\n
Horizontal Only (forms)<\/td>\n1<\/td>\nHorizontal scroll bar appears on the form. Not applicable to text boxes.<\/td>\n<\/tr>\n
Vertical Only (forms) Vertical (text boxes)<\/td>\n2<\/td>\nVertical scroll bar appears on the form or text box.<\/td>\n<\/tr>\n
Both (forms)<\/td>\n3<\/td>\n(Default for forms) Vertical and horizontal scroll bars appear on the form. Not applicable to text boxes.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
From: https:\/\/msdn.microsoft.com\/en-us\/library\/office\/ff834790.aspx?f=255&MSPPError=-2147217396<\/a><\/p>\n
(Though the page says Office 2013 or later this property has been available since Access 97, so, feel free to use in earlier versions of Access.)<\/em><\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Subforms are a little peculiar when used as Continuous Forms\u2026 when the Subform produces 3 records which, in this example, calls for the Scrollbar and you then switch, from the Main Form, and you only have two records or less showing you have this shadow area where the Scrollbar used to be (Figure2)\u2026 slightly annoying […]<\/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":[5],"tags":[64,41,18,72],"class_list":["post-1052","post","type-post","status-publish","format-standard","hentry","category-access-tips","tag-access-tips","tag-continuous-forms","tag-database-design","tag-scrollbars","odd"],"a3_pvc":{"activated":true,"total_views":1336,"today_views":0},"_links":{"self":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1052"}],"version-history":[{"count":7,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1052\/revisions"}],"predecessor-version":[{"id":1175,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1052\/revisions\/1175"}],"wp:attachment":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}