Anchoring a button in an Access Report to always be at top-right corner

[LindaRuble]

Hello,

I would like to be able to "Anchor" a button in a report so that the button is always in the top left corner no matter how the report is sized or even if the report goes beyond the width of the monitor screen. In other words, you will always see the button on the top right hand corner even if you have to horizontally scroll to get to the right most end of the report. I want the button always at the top-right hand corner, visible and accessable.

I know that you can do that sort of thing with an Access Form but I can not find the same Anchoring ability for an Access Report. For a Form when you are in "Design View" and click on a button that you want to anchor, you can go to the Arrange tab -> and in the "Size" panel you click "Anchoring". You will get a fly-out and you can select "top-left", "top-right", etc.

I am hoping that there is a way to do the same for Reports. Perhaps with VBA?



Thanks

[June7]

Never heard of nor used 'anchoring' on forms. Not sure what it does.

Reports are not intended to be interactive. Buttons won't even work from Print Preview. I tested placing a button in upper left of report Header section. It stays there.

Not really understanding your issue.

[LindaRuble]

Hello June7,

What I need to happen is to place the button on the TOP-RIGHT corner. I do NOT want to have the button stay in the same place. It needs to move so that it does not get cut off since the report is wider then the monitor screen. The report scrolls from side to side. I want to always be able to see the button on the TOP-RIGHT hand corner of the report, at the top right corner of the computer monitor. BTW, this button closes the form.

Hope this better explains what I want.

Thanks


Linda

Never heard of nor used 'anchoring' on forms. Not sure what it does.

Reports are not intended to be interactive. Buttons won't even work from Print Preview. I tested placing a button in upper left of report Header section. It stays there.

Not really understanding your issue.

[June7]

Oh, your post referenced both top-right and top-left so was a bit confusing.

The button closes form or report (you said 'form')?

Why not just use the intrinsic X close?

Since reports are not intended to be interactive, MS thought it made sense not to offer same options on reports that are available on forms. Forms can be manipulated by code or property settings even after opened but reports are different animals. Just can't do some things, not even with VBA. Altering a report after it is rendered is one of those things.

[LindaRuble]

Hi,

The intrinsic X to close the report for some reason does not shut down the application, just closes the report. Since I have hidden the main application window and always close the previous pop-up, modal form or report when opening another form or report, I have no way to shut down the application. This is a problem when I want to launch my application again since it does not launch (or at least I don't see it - probably because of the hidden application window). The only way to shut down the application at this point is to hit control, alt, & delete to bring up the Windows Task Manager.

That is why I use the use the close button.

I understand that reports are different than forms but I was hoping that some genious on this forum would have a work around.

Hope someone comes up with the answer.

Linda

Oh, your post referenced both top-right and top-left so was a bit confusing.

The button closes form or report (you said 'form')?

Why not just use the intrinsic X close?

Since reports are not intended to be interactive, MS thought it made sense not to offer same options on reports that are available on forms. Forms can be manipulated by code or property settings even after opened but reports are different animals. Just can't do some things, not even with VBA. Altering a report after it is rendered is one of those things.

[June7]

You want the app to close when this report is closed?

Can have code in the report Close event.

[LindaRuble]

Please tell me how to do this. Thanks

Linda

You want the app to close when this report is closed?

Can have code in the report Close event.

[LindaRuble]

Never mind. I wasn't thinking. Know how to do it. Thanks

You want the app to close when this report is closed?

Can have code in the report Close event.

[LindaRuble]

OK, new problem. When I assign close code to report close event, even when I click a button to go to another page, the page that you are leaving is programed to close so the entire program closes before the next page opens. Hmmm...

[June7]

Don't know what you mean by 'page'. Describe in plain English what you want to do. Post code for analysis.