Define Form Size

Tanya7

New member
Local time
Today, 19:29
Joined
Sep 28, 2012
Messages
8
Hi All,

I'm using Access 2010 and the Setting for Document Window Options(File->Options->Current Database) is "Tabbed Documents".

With this background how does one define the size of the Forms. I do not wish to change the above settings to "Overlapping Windows"

Any help?

Regards,
Tanya
 
You can't unless you open them as dialogs or popups.

Tabbed forms stretch to fill access's MDI area (there's maybe a more correct term for it).

A dialog or popup form appears above the MDI area with a border and title bar and you can set its size at design or run time.
 
Even with tabbed froms you are try Anchoring. This covers horizontal Anchoring.

With a Continuous From you choose the field to "stretch" and then anything to the left is Anchored Left and Anything right is Anchored Right.

With a Continuous From you Choose the fields that can "stretch" not side by side as these will run into each other. Again Anchor left of the stretched Control(s) and right on the other side.

This way it does not matter what happens to the Form Size. It is not very sophisticated but it does the job.

Here are a couple of scripts to hide the Navigation and Tool Bars oops! Ribbon.

Code:
Function Database_Window_Hide()
    With CodeContextObject
        DoCmd.SelectObject acTable, , True
        DoCmd.RunCommand acCmdWindowHide
        DoCmd.ShowToolbar "Ribbon", acToolbarNo
    End With
End Function
Code:
Function Database_Window_Reveal()
    With CodeContextObject
        DoCmd.SelectObject acTable, , True
        DoCmd.SelectObject acForm, .Name
        DoCmd.ShowToolbar "Ribbon", acToolbarYes
    End With
End Function
Simon
 
Last edited:
Thanks VilaRestal and Simon for your valuable inputs.

Regards,
Tanya
 

Users who are viewing this thread

Back
Top Bottom