Subform in Tab

[Bongobob21]

Hi,

I created a form on which are 3 tabs. In all those tabs are subforms with searchfields. When I click on one tab the Form "scrolls down" until the top of the subform. Therefore the tabs on the top are can"t be seen anymore. I would like to stop access from scrolling down, so that the tabs on the main form are always visble.


Does anybody know how to force access to do this?

thanks!

[ItsMe]

Perhaps you can adjust the size of the controls, subform controls, etc. Adjust everything while in design view so it resides in the upper portion of your Main Form.

[Missinglinq]

If it scrolls down to where you can't see the top of the Tabbed Control, the length certainly needs adjusting, as ItsMe suggested; one of the most user-unfriendly things you can do is to require a user to scroll in order to see all parts of a Form!

The direct cause of this is probably that Focus is going to a Control near the bottom of the Subform in question. To prevent this, on the Form the Subform is based on, is to use code like this:

Private Sub Form_Current()
 FirstControlName.SetFocus
End Sub

where FirstControlName is just that, the name of the topmost, probably left side of the Form.

Linq ;0)>

[Bongobob21]

I fortunatly this doesn"t work.
Maybe it is a little bit complicated, but would it be possible to create a macro saying, if that tab is clicked scroll up?

[June7]

Resizing the subform container and tab controls should fix this. Forms should be sized for display on smallest monitor will be viewed on.

So why didn't it fix?

Maybe need to change TabOrder property of controls in the subforms.

Bing: access vba scroll to top of form

http://www.utteraccess.com/forum/Scr...-t1762931.html

[Bongobob21]

The Focus is going to the box an the far top of the subform. Therefore it just scrolls down tha the top of the subform is just right below the header of the mainform.

[Bongobob21]

I created a textbox on top of the page which gets the focus when the Tab Control is updated (as explained by you guys). This works perfectly with the OnUpdate event of the Tab control, so if I change the tabs it doesn't scroll down that far anymore (just a very little bit, which is fine).

But when I click the same tab two times in a row (so the tab control is not updated), the old problem is created of scrolling down. To solve this I inserted the same code in the OnClick event of the tab Control, but the OnClick doesn't help at all...