{"id":211,"date":"2015-12-26T15:29:18","date_gmt":"2015-12-26T20:29:18","guid":{"rendered":"http:\/\/access-diva.com\/blog\/?p=211"},"modified":"2016-07-08T21:04:01","modified_gmt":"2016-07-09T01:04:01","slug":"changing-a-label-caption-on-a-report","status":"publish","type":"post","link":"https:\/\/access-diva.com\/blog\/?p=211","title":{"rendered":"Changing a Label Caption on a Report"},"content":{"rendered":"

If you do Quotes and Invoicing (or Purchase Orders and Invoicing) they generally share the same layout, the only difference being the Label identifying them.\u00a0 Rather than creating to reports you can change the Label Caption depending on which Form you are opening it from.<\/p>\n

Step 1\"Caption\"<\/p>\n

Create the Report and for the Label Caption put the name of the one that is used more often.\u00a0 So, for my Report I put Invoice<\/strong> because I print a lot more invoices than I do quotes.\u00a0 Make sure the Label is long enough to accommodate the character count of the longest word, i.e. Purchase Order<\/strong>.<\/p>\n

Step 2
\nIn the Reports On_Open event place…<\/p>\n

 \r\n  If Not IsNull(Me.OpenArgs) Then\r\n      Me.Controls("lblInvoice").Caption = Me.OpenArgs\r\n  End If\r\n<\/pre>\n
…save and close the Report.<\/p>\n
Step 3
\nFrom the Form that you use to generate your Invoice there is nothing to do, so, go to the one that you use for Quotes.\u00a0 In Design Mode go to the Command Button(s) you are using for Preview (and\u00a0Print, if you have one).\u00a0 Between the Private Sub…<\/strong> and End Sub<\/strong> enter…<\/p>\n
\r\n    Dim strCaption As String\r\n    strCaption = "Quotation"\r\n<\/pre>\n
Then depending on whether you have a WHERE clause…
\nNo WHERE clause<\/p>\n
\r\n    DoCmd.OpenReport "rptInvoice", acViewPreview, , , , strCaption\r\n<\/pre>\n
With a WHERE clause (This sample only includes where the WHERE would go.\u00a0 \ud83d\ude42 )<\/p>\n
\r\n    DoCmd.OpenReport "rptInvoice", acViewPreview, , strWhere, , strCaption\r\n<\/pre>\n
(Don’t forget some Error Code!)\u00a0 Save, close and test! All done!<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
If you do Quotes and Invoicing (or Purchase Orders and Invoicing) they generally share the same layout, the only difference being the Label identifying them. Rather than creating to reports you can change the Label Caption depending on which Form you are opening it from.<\/p>\n
Step 1<\/p>\n
Create the Report and for the Label Caption […]<\/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,25],"tags":[89,88],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","category-access-tips","category-reports","tag-label-caption","tag-reports","odd"],"_links":{"self":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/211","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=211"}],"version-history":[{"count":9,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":385,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/211\/revisions\/385"}],"wp:attachment":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}