Report Pop-up Size Uncontrollable

[Stang70Fastback]

Just a really stupid question, as I must be doing something blatantly wrong. I have a Report that displays as a pop-up which is the 'front end' to my program. Basically a whole bunch of buttons to open various other reports and/or external links, etc...

I have this report set to open as a pop-up dialog box, and I am able to get it to display at the correct width (just as wide as the report, with no extra white space) and it is centered on the screen, however I cannot for the life of me figure out how to limit the vertical size of the box. It will always default to as tall as the computer monitor is, minus some sort of buffer, essentially the size of the start menu at the top and bottom of the screen.

This doesn't inhibit the functionality of my program in any way, but it's definitely an eyesore since the form is not very tall and so you have the top half of the window displaying my report, and the bottom half of the report is just white space that I CANNOT get rid of. The report itself is only so high. I have no headers and footers. JUST a detail section that is a few inches high, but the larger of a resolution screen you open it up on, the taller the window will be. It seems to just default to the maximum displayable height.

I have messed with all sorts of form properties (auto resize, auto height, can grow/shrink, etc...) but to no avail.

What am I doing wrong? HELP!

Thanks!

 

[JHB]

... have a Report that displays as a pop-up which is the 'front end' to my program. Basically a whole bunch of buttons to open various other reports ...

... messed with all sorts of form properties (auto resize, auto height, can grow/shrink, etc.....

First of ALL is it a report or a form??? Report is usually NOT used as a "front end", but forms are - "Switchboard" is it sometimes called.
Take a screen dump and show what is wrong and how you want it. (Powerpoint is good to use if you want to put in text in the picture or cut it or ...! The picture can be uploaded as ZIP if you not have posted 10 post yet).

 

[Stang70Fastback]

Well, thank you for confirming that I am in fact a complete idiot, lol. This is the first time I've done anything with Access... which is funny because this has turned into a beast of a program. I've been learning as I go, through trial and error, and never messed with Forms, so I thought a Report was the proper way to do things.

I just created a Form, copied and pasted everything to it from the Report, and now everything works the way I want it to, and I'm not doing it wrong! Lol.

Thanks for the help, that was all I needed!

Now I have to go into my list of Macros and change all the commands from [Reports]![Front End] to [Forms]![Front End]...
...any chance there is a 'Find and Replace' tool? Lol.

 

[JHB]

You're welcome.

Well, thank you for confirming that I am in fact a complete idiot, lol

No, you are not an idiot, you didn't know better, it is a very big different.

...because this has turned into a beast of a program ...

It is like a cat purrs when you scratch it's back.
Good you got what you want. Good luck with you projekt.