Proble with form size

Hi
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
Robert
titorober23Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ldunscombeCommented:
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.

eg

DoCmd.Maximise
DoCmd.Minimise
or
DoCmd.MoveSize([Right],[Down],[Left],[Right])

Leigh
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
titorober23Author Commented:
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.
0
ldunscombeCommented:
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.

Leigh
0
clarkscottCommented:
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
0
RomoloIT Pro, Projects, Mentor, TrainerCommented:
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

MsgBox CONTROLORFORMNAME.Left & " " & CONTROLORFORMNAME.Top & " " & CONTROLORFORMNAME.Width & " " & CONTROLORFORMNAME.Height

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

R
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.