{"id":865,"date":"2013-12-02T20:02:59","date_gmt":"2013-12-03T01:02:59","guid":{"rendered":"http:\/\/regina-whipp.com\/blog\/?p=865"},"modified":"2016-07-08T23:01:37","modified_gmt":"2016-07-09T03:01:37","slug":"report","status":"publish","type":"post","link":"https:\/\/regina-whipp.com\/blog\/?p=865","title":{"rendered":"Adding *continued…* to a Multicolumn Report…"},"content":{"rendered":"
After seeing a post in a Forum<\/a>\u00a0asking about\u00a0how to add the word *continued…* to a Multicolumn Report\u00a0I thought it would be fun to create a sample database showing off the feature, to\u00a0download\u00a0click\u00a0here<\/a> (Access 2007 or above needed and an unzipping program.\u00a0 Images are not<\/strong> included!).\u00a0\u00a0And, of course, like everything else, I could not just stop at just doing a simple Multicolumn Report… so, I added the ability to add pictures at the beginning of each Articles (or not), printing Articles or Publications, like Newsletters!\u00a0 (To read more about that click here<\/a>.)<\/div>\n
<\/div>\n
\n
\"Figure

Figure 1<\/p><\/div>\n<\/div>\n

<\/div>\n

The How…<\/strong>\"Continued\"<\/h4>\n
\n

In this example I am using a 3 column report.\u00a0 Fields needed\u00a0are…<\/p>\n

tblArticles
\naTitle<\/strong>
\nControls needed on the report are…<\/p>\n

txtTitle<\/strong>– Unbound\u00a0 and in the aTitle Header<\/strong> section
\ntxtTitleHidden<\/strong> – Bound to the field in the table that holds the Title, placed in the aTitle Header<\/strong> section.<\/p>\n

Place both controls, txtTitle<\/strong> and txtTitleHidden<\/strong> in the aTitle Header<\/strong> section.\u00a0 Set the aTitle Header<\/strong> section\u00a0to Can Grow<\/strong> and Can Shrink<\/strong> properties to Yes<\/strong> and set the\u00a0Repeat Section<\/strong> property to\u00a0Yes<\/strong>.\u00a0 Then in aTitle Header On_Format<\/strong> event place…<\/p>\n<\/div>\n

 <\/p>\n

\n

 <\/p>\n

Private<\/span> Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)<\/span><\/p>\n

\r\nStatic strLastValue As String\r\n'Posted by Pat Hartman (Access MVP) \u00a0http:\/\/www.access-programmers.co.uk\/forums\/showthread.php?t=57847  on 11.19.2003\r\n'Modified by Gina Whipp 11.13.2013 to change color, size and position when Article is continued\r\n\r\nIf Me.txtTitleHidden = strLastValue Then\r\n   Me.txtTitle.Visible = True\r\n   Me.txtTitle.Properties("TopMargin") = 0.05 * 1440\r\n   Me.txtTitle = Me.txtTitleHidden & " ...continued"\r\n   Me.txtTitle.ForeColor = RGB(140, 140, 140)\u00a0 'Grey\r\n   Me.txtTitle.FontSize = 10\r\n   'Author is optional\r\n   'Me.txtAuthor.Visible = False\r\nElse\r\n   Me.txtTitle.Visible = True\r\n   strLastValue = Me.txtTitleHidden\r\n   Me.txtTitle = Me.txtTitleHidden\r\n   Me.txtTitle.ForeColor = RGB(0, 0, 0)\u00a0 'Black\r\n   Me.txtTitle.FontSize = 11\r\n   'Author is optional\r\n   'Me.txtAuthor.Visible = True\r\nEnd If\r\n<\/pre>\n
End Sub<\/span><\/p>\n<\/div>\n
All done, you can run your report!<\/div>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
After seeing a post in a Forum asking about how to add the word *continued…* to a Multicolumn Report I thought it would be fun to create a sample database showing off the feature, to download click here (Access 2007 or above needed and an unzipping program. Images are not included!). And, of course, like […]<\/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,63],"tags":[18,46,47,30],"class_list":["post-865","post","type-post","status-publish","format-standard","hentry","category-access-tips","category-database-design","tag-database-design","tag-image-handling","tag-multicolumn-report","tag-reports","odd"],"_links":{"self":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/865","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=865"}],"version-history":[{"count":14,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/865\/revisions"}],"predecessor-version":[{"id":1286,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/865\/revisions\/1286"}],"wp:attachment":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}