Form-SubForm ScrollBar problem

[accessNator]

Hello,
First post. Glad to find this. I am using Access 2003.
I have a Form which uses a tab control.
Tab1 has my main form called FrmMain
Tab2 is a subform which has contact information called sFrmContact
Tab3 is a subform which has an unbound form

In my Tab3, which has an unbound form called sfrmInput, I have 20 textbox controls. Being this big it has a vertical scroll bar enabled so you can scroll from top to bottom.

But,When I get to the 15 textbox and exit the box it goes to the 16 textbox which is fine. The problem is the subform does not automatically scroll down so I can see the 16th textbox and so on, I have to manually scroll to see the rest of the textboxes.

My question is how can I force the subform to scroll to the bottom area after the 15 textbox so I can see the rest of the textboxes following?

Thoughts?

 

[wiklendt]

Hi, welcome to the forums.

First, the form on which you have your tabs is technically your main form, all other forms on this one (on the tabs) are considered subforms.

Second, i'm concerned by your database design - is it normalised? what is your table structure like: if you need 20 textboxes that DON'T fit on one form, then you may have a case of illogically stored data.

Third, if you do have a normalise database (if you don't know what this means, then you probably don't have normalised data), separate the texboxes logically to fit on more than one tab, it's easier that way to scan/review data, rather than having to scroll to it.

Fourth, i don't actually know how to force scrolling like that - try doing a search on the forums with keywords such as "automatically scroll" or the like, and not just here but google as well, and other forums: UtterAccess is a good one too.

Good luck with your project.

 

[accessNator]

wiklendt, Thanks for your response.

First, the form on which you have your tabs is technically your main form, all other forms on this one (on the tabs) are considered subforms.

I will have to fix that piece where all the tabs should be subforms. That is a problem on my first tab.

Second, i'm concerned by your database design - is it normalised? what is your table structure like: if you need 20 textboxes that DON'T fit on one form, then you may have a case of illogically stored data.

Yes, its is normalised. My problem was trying to get it to be visually pleasing to the User. I will have to rethink on how to present the layout. I know 20 textboxes are a lot to see, but this particular form requires 20 input boxes for currency values.

Third, if you do have a normalise database (if you don't know what this means, then you probably don't have normalised data), separate the texboxes logically to fit on more than one tab, it's easier that way to scan/review data, rather than having to scroll to it.

It does seem a lot but it has to go on one tab for usabilty.

Fourth, i don't actually know how to force scrolling like that - try doing a search on the forums with keywords such as "automatically scroll" or the like, and not just here but google as well, and other forums: UtterAccess is a good one too.

Basing on your first response. Since I tied the first form (TAB) as a mainform (which I shouldnt do, should be a subform), its scroll bar area was showing up in the other subforms if my subform was long. Now I know it is because I did not structure the Tab control properly.

Thanks again for thinking this out with me. It was helpful.

Cheers.

 

[wiklendt]

Basing on your first response. Since I tied the first form (TAB) as a mainform (which I shouldnt do, should be a subform), its scroll bar area was showing up in the other subforms if my subform was long. Now I know it is because I did not structure the Tab control properly.

yeah, that took me a while to get right - you have to click on the tab itself to 'activate' the tab and put a control (like a subform container) on that tab and that tab alone. glad i could help somewhat, but you may still need that special code for auto scrolling - like before, doing a search in these forums is the best and quickest way i know of to get a specific answer.... WAY too much in here to just browse...

good luck with your project