Can I access an internal print line counter in VBA (Access 2003)

Topic

New Reply

I am generating an Access report. I need to make various VBA decisions based upon the current print line

Reply | Quote

Replies

I’m not aware of an internal counter that is exposed to the user. You can use the Top property of the Report – it represents the distance (in twips, 1440 twips = 1 inch) between the top of the page and the top of the current section.

Reply | Quote

I’m not aware of an internal counter that is exposed to the user. You can use the Top property of the Report – it represents the distance (in twips, 1440 twips = 1 inch) between the top of the page and the top of the current section.

Reply | Quote

That isn’t how Access does it. The report is formatted multiple times in order to determine whether a “keep together” section will fit on the current page. To my knowledge, there is no line counter involved at all, only the Top property and the heights of the footers.

Reply | Quote

Thanks Hans and Charlotte,
Top sounds like a good idea if I can get it to work. I did some experiments displaying Top

Reply | Quote

As I mentioned in my reply, you must use the Top property of the report itself, i.e. Me.Top. What it refers to depends on where you use it. If you use Me.Top in an event of the Detail section, it refers to the distance of the top of the detail section to the top of the page. You can check if this is above, or below, a set limit.

Reply | Quote

Got it. It works beautifully.

Thanks again,

John

Reply | Quote

Got it. It works beautifully.

Thanks again,

John

Reply | Quote

As I mentioned in my reply, you must use the Top property of the report itself, i.e. Me.Top. What it refers to depends on where you use it. If you use Me.Top in an event of the Detail section, it refers to the distance of the top of the detail section to the top of the page. You can check if this is above, or below, a set limit.

Reply | Quote

Thanks Hans and Charlotte,
Top sounds like a good idea if I can get it to work. I did some experiments displaying Top

Reply | Quote

That isn’t how Access does it. The report is formatted multiple times in order to determine whether a “keep together” section will fit on the current page. To my knowledge, there is no line counter involved at all, only the Top property and the heights of the footers.

Reply | Quote