Proble with form size

Posted on 2008-11-11
Last Modified: 2013-11-28
In my 2007 database, i have a main form which call other forms, all of them works fine, but from time to time when i call a form, the forms open really small that i can eve resize it, i really do not know why, i play with the properties, like Modal, Auto Size, border stile, Popup, etc. But they seem to work and them happens again.
I change the way i open the form(vba/ macro), but it's still happening from tiem to time.
Some time if i open the form directly without the min form sometimes hapens, sometimes doesn't.

Any idea what could be causing this.

Best regards
Question by:titorober23
    LVL 14

    Accepted Solution

    Not sure if it's what you are after but but a trick that I use quite often is to set the forms size and position in the OnActivate event of my forms. That way every time a form becomes active it is displayed how I intended.




    Author Comment

    how do i specified a specific size and position?
    because it seems that doe snot matter what i specified in the properties, bcause any way it changes from time to time.
    LVL 14

    Expert Comment

    You don't do it in the property sheet of the forms you do it via code in the OnActivate event, that way it is set automatically every time the form is activated.

    LVL 20

    Expert Comment

    Open the form and size it how it should be.
    Save the mdb.
    View the form in design mode.
    Access the LOAD event.
    Open the Immediate window and type:
    Print appliction.forms("yourformname").insideHeight

    This will show you the InsideHeight value to use.
    In the LOAD event type:
    Application.forms("YourFormName").insideHeight = xxxx   (xxx being the value from the immediate window).
    Repeat for InsideWidth

    This forces the form size always.

    Scott C
    LVL 7

    Expert Comment

    I too have experienced this... it seems to be a Microsoft Feature :)

    What you need to do is place a button on the form to find out exact sizes and put the following code within that button


    This will give you a list of numbers of its current position (This is providing you can load form correctly.. run it in Access2003 :)

    Then on open event of the form...

    place the following with the values you got from msgbox

    CONTROLORFORMNAME.Move 4648, 1820, 1000, 300

    This will guarantee its in the right place everytime it loads

    Its a real pain when ACCESS2007 does this... tbh... I develop in Access2003 then upgrade

    BECAUSE Access 2007 does not have enough to warratn development in vs troublesome less userfriendly interface.

    Still use Access for full system development or as Pilot system


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now