Resize Object After Closing

[Robert T]

I'm sure someone's already answered this but I don't know how to classify
and/or search for the response, so I'll just ask the question. In fact, I'm
having trouble accurately describing the issue.

I have forms with command buttons that are relatively small and centered on
the screen. More often than not, after a command button opens another form
or a report, when that form or report closes, Access reverts back to
something similar to a full screen view. I know there must be a way to go
back to the small size of the form that opened another form or report.

Thanks,
Robert

 

[Golfinray]

Go to the properties of the forms and set pop-up to yes. Make sure your form
is the size you want it. Now your form will be that size each time you open
it.

 

[Robert T]

Golfinray:

Wow! That sounds so simple and I thought I had to write code to re-size the
form each time. I'll give it a try tomorrow morning.

Thanks,
Robert

 

[Robert T]

Golfinray:

That didn't work! It actually made things worse because the calling form
stayed on the screen in the foreground, while the report it was calling was
hidden behind the form with the Pop Up Property set to YES.

Do you have any other suggestions?

Robert

 

[Golfinray]

Set autoresize to no and autocenter to no.

Golfinray:

That didn't work! It actually made things worse because the calling form
stayed on the screen in the foreground, while the report it was calling was
hidden behind the form with the Pop Up Property set to YES.

Do you have any other suggestions?

Robert

 

[Robert T]

Golfinray:

I made the 2 settings changes you recommended and that didn't work either.

1. On a form, I clicked on a command button to preview a report on the
screen. I had to maximize the report so I could read it. When I closed the
report, the calling form, with the 2 settings you recommended, was also full
sized.
2. Even if your suggestion would have worked, it caused another problem
because I want the calling form centered on the screen.

Any other thoughts?

Robert

 

[Rick Brandt]

Golfinray:

I made the 2 settings changes you recommended and that didn't work
either.

1. On a form, I clicked on a command button to preview a report on the
screen. I had to maximize the report so I could read it. When I
closed the report, the calling form, with the 2 settings you
recommended, was also full sized.
2. Even if your suggestion would have worked, it caused another
problem because I want the calling form centered on the screen.

Any other thoughts?

In Access when you maximize one thing you maximize all things. Put code...

DoCmd.Restore

....in the Close event of your report.

 

[Robert T]

Hi Rick:

Thanks so much, that was exactly what I was looking for. So far it appears
to be working great and that's a nice little improvement to our database.

Robert