Location of a Top of Section

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help figuring out the proper syntext to determine where the top of a
section will print on the first page of my report.

Here is one of the attempts I made with no success.

If Me!GroupFooter0.Top = 8200 Then
DoCmd.RunMacro "YesPageBreak"
Else
DoCmd.RunMacro "NoPageBreak"
End If

Thanks in advance!

Dwight
 
Crucial aspect is that code needs to be run in the Format event of the
section that contains the page break control. It may help to add this line
so you can see what Access thinks the Top property is in the Immediate
Window (Ctrl+G):
Debug.Print Me.Top

Probably easier to just set the Visible property of the control rather than
call a macro.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report printing 15
Toggle Button not refreshing 1
Access How to prevent subReport from breaking across pages? 1
Why can I not enter a valid date for this code... 6
Multiple If Then Else Statments 4
Where is My Textbox Printing 1
Report to start Print at Bottom of a page instead of top of page 0
Vertical Lines in Detail Section of Report 1

Back
Top