Form size (1 Viewer)

[phatus]

hi i want my form to be manimize the space

attached here is the screenshot of minize form... my form is in maximize

My Form:

i want my form to be like this size.

 

[phatus]

anyone how to do it? ive searching in the net and cant find 1 thank you...

 

[John Big Booty]

In the form's On Load event put;

DoCmd.Maximize

Note this will cause all forms other than Pop Up forms to open maximised.

DoCmd.Restore

Will cause all subsequent forms to open at their normal (un-maximised) size.

 

[phatus]

where im going to put it in the form properties? i tried On load>docmd.minimize in that form but nothing happend.. ill try your suggestion sir

Private Sub Form_Load()
DoCmd.Maximize
End Sub

nothing happen sir.... i save it close and reopen again the database

 

[John Big Booty]

where im going to put it in the form properties? i tried On load>docmd.minimize in that form but nothing happend.. ill try your suggestion sir

Private Sub Form_Current()
DoCmd.Minimize
End Sub

DoCmd.Minimize will minimize your form if you want to return the form to return your form to it's design size use DoCmd.Restore any of those commands will work in the On Current event, But I would put them in the On Load event and then reverse it in the On Unload event.

If the code did nothing, have you got your trust setting correctly set to allow code to run?

 

[phatus]

sir nothing really happen my trust setting is enable...

 

[John Big Booty]

Check the attached sample

 

[phatus]

ok sir kindly look my sample i based it in your sample but still it didnt work.. can you fix it... i know i put the code in the right place...

 

[John Big Booty]

OK, here's what you need to do.

Click on the round Office Button in the top left hand corner of your screen. Along the Bottom margin of the dialogue window that will open you will see a button labelled Access Options, click this button. A new dialogue box will open, click on Current Database from the list in the left margin. About a third the way down you will see a heading Document Window Options select Overlapping Windows from the two options, and click the OK button. Another Dialogue window will advise you that you will need to close save and close the DB, before the changes you have made will take effect.

 

[phatus]

yes it work! a very thank you to you sir... ^ ^