Basic Form Aesthetics

[Ollie_3670]

In the old(er) Access of around 2000-2003 you used to be able to create a form, set it's size, where it pops up on the screen and it's general appearance. I see most of these features still exist however, I'm having one major problem.

All the forms I create, seemingly appear maximised to take up a lot of room. If I just want a menu form (or switchboard, whatever they are called now). With two buttons and a back button, I don't want a whole tab's worth of form to appear.

My preferences are to:

A) work out how to open a form that is only as large as the grey template backing in design view

B) Completely maximise each form (to whole computer screen size). I've already tried the DoCmd.maximise on form load..but doesn't do anything?

I'd really appreciate your input,

Ollie

 

[pbaldy]

Check the setting for Document Window Options in Office Button/Access Options/Current Database. It sounds like its Tabbed, and you don't want it to be.

 

[Ollie_3670]

Great, didn't even see that "access options" button. Easy to miss!

 

[pbaldy]

No problemo! It does kind of hide at the bottom, doesn't it?

 

[ghudson]

I also prefer to set the size of my forms...

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open

    'MsgBox "InsideHeight = " & InsideHeight & vbCrLf & vbLf & "InsideWidth = " & InsideWidth
    InsideHeight = 5000
    InsideWidth = 7695

 

[vbaInet]

I also prefer to set the size of my forms...

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open

    'MsgBox "InsideHeight = " & InsideHeight & vbCrLf & vbLf & "InsideWidth = " & InsideWidth
    InsideHeight = 5000
    InsideWidth = 7695

I do that too but in relation to the screen width and height

 

[pbaldy]

I just size mine in design view and save, plus I generally use a border style of Dialog so it can't be changed.