Window – size to fit form (A97)

Topic

New Reply

I have a form with some command buttons that run queries and then open a report in preview mode. The form is about five inches by three inches, and it opens in a window sized to fit it. So far, so good.

The reports open in a window that is too small to be useful – so the natural reaction is to maximize the window. However, when the user then closes the form view (typically after printing) the form loads again – but now it is in a maximized window, leaving the form in the upper left with an ocean of gray around it. The user MAY think to ‘restore’ the window (and then we are all happy) or he may try to close via the “X” close box (and then we are not happy). Either way, it looks very sloppy.

I have looked for a command that would re-size the window back where it should be that I could attach to the ‘gotfocus’ event – it seems available for controls, but not for the window. Does anyone have any suggestions?

Reply | Quote

Replies

In the On Activate event of the form enter Docmd.Restore

Reply | Quote

BINGO!

Thanks, Francois – works like a charm.

It boggles my mind sometimes: – ask a question in Vancouver, Canada, go to lunch; and get an answer from Belgium!

Reply | Quote

If you pay the trip, I bring you the aswer, but you’ll have to wait … say 24 h. Canada is one of the country’s I want to visit someday.

Reply | Quote

Hey Dean — if you don’t mind another answer from someone closer to home — also in Vancouver.

As standard operating practice, I put docmd.maximize in the Open event of all reports, and docmd.restore in the close event. That way you don’t have to worry about which control was used to launch the report.

Reply | Quote

Jack –

I’ll take help from wherever I can get it! Thanks, that was a good suggestion and I will keep it in mind.

Reply | Quote