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 […]

 163 total views,  2 views today

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 […]

 283 total views,  1 views today

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 […]

 1,250 total views