Access MVP (2010-2015)


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

 261 total views

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

 379 total views

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,661 total views

Refer to Controls on Forms/Subforms

It’s always a nightmare when you’re trying to reference a control from one Form to another or one Report or another. You think you’ve typed it correctly but it’s still not returning the value. Here are two ways to get that accomplished…

From The Access Web… Refer to Form and Subform properties and controls



 3,128 total views