Forms not opening at the top

[Saudi Mike]

My newest twist. I have a form that has multiple buttons that open various forms. All work properly except one. I open it and it opens near the bottom of the screen. All my other forms open with the top of the form. I've been comparing various form properties between the one that doesn't open properly and the others that do and can't seem to find any difference.

I should have noted that when I have the form open and move to the next record, the form again goes down to the bottom of the screen. Since all the overall data is at the top I have to keep scrolling up to the top to see this info. Painful

 

[vbaInet]

Are you saying that the form window is moving to the bottom of the screen or the record selector is moving to the last/bottom record?

 

[Saudi Mike]

Ahhh.. good point. Record selector? This particular form is only reporting data, there is no data entry here. Is there still a default position used for opening the form?

As is the form is opened, I am viewing the bottom of the screen. i should be viewing the top.

I should have mentioned, this form also has two sub forms in it. I don't know if that is part of the problem, but it is not an issue on the other forms.

.

 

[vbaInet]

Upload a screenshot of what you're talking about so I can take a look.

Zip the image, click the "Go Advanced" button (it's next to the "Post Quick Reply" below the Message box) and you'll see where to upload the zipped document.

 

[Saudi Mike]

File 1 is what the form should look like.

File 2 is what is actually looks like.

 

[vbaInet]

Ok, upload a screenshot of the form in Design View.

 

[Saudi Mike]

Due to the size of the form, the design view screen shot is in two views 3 and 4.

 

[vbaInet]

It's just scrolling down to the subform because it is the first in the tab order. Look for the Tab Order button and change the order.

 

[Saudi Mike]

Hmm... ok.. I'm looking for the Tab Order Button. Hint on where I should be looking?

 

[Saudi Mike]

ok... I remembered where tab order was under the 'design' options. but I don't see anything out of order nor any difference between this form and the other.

 

[CJ_London]

simply - the form is too big for the screen. Try reducing the height of the bottom subform control on your main form and removing any unnecessary 'white space' - looks like you have some on the main form below the subform control.

To allow for differing screen sizes in the main form resize event put the following

mysubformcontrol.height=insideheight-mysubformcontrol.top-60 'to allow a small margin

replace mysubformcontrol with the actual name of your subform control.

with this command you can reduce your subform height to a couple of centimetres and remove all the whitespace below. Then when the form opens, Access will show as much of the subform as it can. Make sure subform itself has vertical scrollbar set to true. You can also remove the record select for this form as well if you want

 

[Saudi Mike]

Well, I think it was a good effort, but it's got to be something else. i don't seem to get any change. Further, there's a near identical form with regard to information type and form heights and that one opens at the top of the form even though there is nearly twice as much form as can fit on the screen.

 

[Saudi Mike]

Got it! Turned out the subform actually did not have ENOUGH space. On a lark I tried resizing both sub forms and I added height and that did it. Go figure.