dialog box resizing problem

[frankie13]

i have a presentation of my database application in 5 hours times, and i have the simplist of problems, but cant find the solution anywhere.

i have a search dialog box (frmDialog) that pops up from the result of another frm command button. I want my dialog box to be a certain size and centered. Unfortunately the dialog box pops up MAXIMIZED and looks awful.

how do i keep the previous form property as Maximized, and the dialog form as a specific size???

please help asap!!!!

many thanks

 

[NoMAd]

im pretty sure you can change the heights of the form...

i know you can at least change the width, its under the format tab under the forms properties.. and try subdatasheet height.. im not sure if that will work tho..

just browse the formats of the form and see if you can find nething.. apart from that im not sure.

hope i could help

 

[Mile-O]

Have you set the dialog form's PopUp Property and Modal property to True as well as the Auto Centre property?

 

[ghudson]

You can easily force the size of a form when needed.

Here is some code I use in the forms OnOpen event to force my forms to the size I want...

'    MsgBox "InsideHeight = " & InsideHeight & vbCrLf & vbLf & "InsideWidth = " & InsideWidth 'used for testing
    InsideHeight = 5000 'twips
    InsideWidth = 6000 'twips

You can also use the MoveSize method to set the size and postion the form in one line of code.

DoCmd.MoveSize 1440, 2400, 1000, 2000

Check the Access help files for more info on using the InsideWidth & MoveSize commands.