Form question (2000)

Topic

New Reply

I have a form that has a right scroll bar. When I open the form, the right scroll bar is down a little so that you have to push it up to see the top of the form. I have tried all the properties to try to correct this. Is there something I am missing so that the form opens so the top of the form isn’t hidden? Thanks for any help.

Reply | Quote

Replies

This happens to me lots – even when you size it correctly in normal view and save it, it returns to being small. The following have sorted it for me:
1) Go to the design view of the form.
2) Drag out the sides of the form to make them larger (in this case taller)
3) Click on the SAVE button on the tool bar.
4) Shut the form down.
5) Reopen it again – it’s normally fine then.

If that doesn’t work – see if the Auto Resize property of the form is set to Yes. If it is, try No. This last one has applied to me when I am using sub-forms in a way I’m sure I shouldn’t!

Hope that helps

Tony

Reply | Quote

Thanks Tony but no luck. The form still opens with the scroll bar part way down, hiding the top of the form.

Reply | Quote

Are the field(s)/label(s) that you cannot see in the Header or in the Detail? If there are field(s) that are not shown, does it make a difference if you change the tab order so that the one at the top is first? (or is it already?)

Reply | Quote

The form has a option group control on it with option buttons in side the option group control. It just has a detail section. The top of the form has two command buttons etc. When the form opens the right scroll bar is part way down, hiding the command buttons and the top of the option group control.

Reply | Quote

Two things to look for:

1- In the forms properties, see if the ScrollTop property is set to something other than 0.

2- See if the form has an initilize event routine that is setting the ScrollTop of the form to something other than 0.

Reply | Quote

I can’t find the property ScrollTop in the forms properties. The form has an on activate event that has DoCmd.Restore.

Reply | Quote

Sorry, I thought I was in the Excel forum and this was an Excel userform question. I don’t know how this works on an Access form.

Reply | Quote

I would set the AutoResize property of the form to Yes. If that doesn’t help, try the following:
– Open the form in form view.
– Select Window | Size to Fit Form.
– Select File | Save.

Reply | Quote