peispud
asked on
Button control in access 2010 report
Hi
I have a button control in my Access 2010 report.
The report is large so when I scroll down, the button scrolls off the visible screen. I can't seem to find out how or where to keep a button or other control so that it doesn't go off the screen when I scroll down on the data.
I have a button control in my Access 2010 report.
The report is large so when I scroll down, the button scrolls off the visible screen. I can't seem to find out how or where to keep a button or other control so that it doesn't go off the screen when I scroll down on the data.
ASKER
The report has a field called [Invoice Num].
The value of this field as read by will be read into a varaible using the Report_Current event.
This varaible will be used to set a filter for the report.
So, I need to be able to see both the button control and the desired record (which may be on page 2 of the report).
The value of this field as read by will be read into a varaible using the Report_Current event.
This varaible will be used to set a filter for the report.
So, I need to be able to see both the button control and the desired record (which may be on page 2 of the report).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can get the visual results you want by displaying the report in Print Preview, but lose the button's functionality.
A workaround might be to place your button on a ribbon associated with the report instead of on the report itself.
A workaround might be to place your button on a ribbon associated with the report instead of on the report itself.
ASKER
I've started to look into ribbons for access 2010. I will accept your idea, but can't really spend too much time right away learning how to do this.
If you have any suggestions, then I will study them.
Thanks
If you have any suggestions, then I will study them.
Thanks
ASKER
Thanks
What section (Report Header, Page Header, group header, detail, group footer, page footer, report footer) do you have it in?