Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Print Constant Number of Lines (or Add a Constant Number of Lines)

This topic comes up from time to time in Forums and the answer usually involves a Temp Table or adding blank records or digging up that Microsoft® Report Utilities, How to Print a Constant Number of Lines per Group, sample which involved adding the controls you wanted to *hide* to the Function.  I thought why […]

Loading

July 29th, 2019 | Tags: | Category: Access Tips, Reports | Comments are closed

What happened to my Form Icon?

So, you checked Use as Form and Report Icon under Options > Current Database for your customized Icon to show on your Forms and Reports but when you opened your Form (or Report) there’s no icon…

Well, here’s the thing, if you choose No in the Properties window for the Form (or Report) under […]

Loading

July 28th, 2018 | Tags: , , | Category: Form Design, Forms, Reports | Comments are closed

Changing a Label Caption on a Report

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.

Step 1

Create the Report and for the Label Caption […]

Loading

December 26th, 2015 | Tags: , | Category: Access Tips, Reports | Comments are closed