Link to home
Start Free TrialLog in
Avatar of peispud
peispudFlag for Canada

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.
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

It will depend on the purpose of the button?  What do you want the button to do?

What section (Report Header, Page Header, group header, detail, group footer, page footer, report footer) do you have it in?
Avatar of peispud

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).
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of peispud

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
Avatar of peispud

ASKER

Thanks