Making a form so its not a whole page. Must be so simple

[nicky1234567]

i have created a form based on a query and basically the form comes up as a whole page spread and i would like it to just come up as a small form instead of a whole page. i think i go into properties and then choose the actual form but i just need to know how to make it so its small.

Hope this explanation is adequate

Thanks

Nicholas

 

[Tim L]

Sounds like perhaps your form is maximizing when it opens, to fill the database window?

If you change the form properties:

Format\Border to Dialogue
Format\Autoresize to No

and,perhaps,

Other\Pop Up to Yes

Then modify the form in design view to the size you require by altering the form page size and window size, finally save. Re-open and it should open up at the size you have just set. If it still maximizes check in the On Open Event for DoCmd.Maximise and on the code behind any buttons that open the form for simliar instructions.

HTH

Tim

 

[nicky1234567]

thanks, that has sorted the problem