Access 2007 Problem

[John M]

I just recently updated from 2002 to 2007. Now i find some of my forms when
opened are just a small square in the top left corner of the screen. i have
tried resizing them and they work fine till i close the program and then
reopen it, when they go back to the small square again. Also, in the process
of expanding the forms, sometimes Access crashes and comes up with an error
message to send to microsoft. This is extremely tiresome and sometimes makes
the program nearly unusable. This never happened at all in 2002
As i use it for my business any help on this matter would be greatly
appreciated.

John M

 

[Danny J. Lesandrini]

What happens if you put this code in the Open event?

DoCmd.Maximize
or
DoCmd.Restore

Also try adding & playing with this.
DoCmd.MoveSize 0,0,4000,4000


Alternatively, if any of these exist, try commenting them out and see if that helps.

Also, check to see if there is any code on the Form_Resize()event.

 

[Damon Heron]

I struggled with the same problem when I switched to 2007. I called them
"sliver forms". Eventually, I ended up setting the width and height of all
my forms in the form resize event:

DoCmd.MoveSize , , 6040, 5040 '(thats right, down, width, height)

and I also set auto resize property to no, although don't know if this was
necessary.

Damon

 

[Mark Andrews]

I've seen the small square. I just resized the screen and pressed save and
it seemed to take from then on.

Not sure on the crashing, do you have SP1.
Try Allen brownes site for tips on crashing.

Mark
RPT Software
http://www.rptsoftware.com

 

[John M]

Sorry for so long to reply
The DoCmd.Restore wouldnt work consistantly. I have found using the Movesize
command is the only one that totally fixes the problem. It has meant i have
had to go through all my forms and set the size in the 'on load' event. But
at least it now works.
Thank you very much, and the others that replied as well, for your help.

John M.

 

[BATISTA RIBEIRO JOAO SAMUEL JOAO SAMUEL BATISTA RI]

Sorry for so long to reply
The DoCmd.Restore wouldnt work consistantly. I have found using the
Movesize
command is the only one that totally fixes the problem. It has meant i
have
had to go through all my forms and set the size in the 'on load' event.
But
at least it now works.
Thank you very much, and the others that replied as well, for your help.

John M.