form size

[kabir_hussein]

Hi i am trying to do a dialog box version form(look at the attachment will explain) however when i adjust the size it works fine when i exit the database and reopen it. But when i click on another form that is set to maximse on load and then close that and try open the dialog box the form becomes full screen as well.

anyone know what is goin wrong

many thanks

 

[Mile-O]

How are you opening the form? With the OpenForm method? If so, then remember to explicitly state that you want it to open as a Dialog form using the acDialog constant for WindowStyle.

 

[kabir_hussein]

hi

many thanks for the reply, the dialog form is opened with no openform method.
if i was to do the way u said how would i do it as i have no idea

thank you for help

 

[Mile-O]

The OpenForm method is one line of VBA.

DoCmd.OpenForm "MyForm", , , , , acDialog

 

[Rich]

DoCmd.Restore on the Close/Unload event(s) of the Maximised form(s)