Jumping Tabs

[bill33]

I am working on a form that will put information into 5 tables. I am putting standard information in the parent form. Then I am using the "Tab Control" tool to create 4 child subforms that will build on the parent form.

The problem I am having is, although tabs 1, 3 and 4 do not change or move when I go to form view and click on the specific tabs, the second form, which is the most complicated subform, tends to jump up on the screen and I have to scroll up inorder to put in any data.

I have tried resizing, and moving the controls, but I cannot seem to get it to work.

I know there must be some locking function, or anchor for the tab control, but for some dumb reason I just cant see it.

Any suggestions?

 

[georgedwilkinson]

I know exactly the problem you're facing. It is quite annoying.

The problem is that Access does not have a WYSIWYG designer. You need to move the "handles" of the subform on the problematic tab so that the subform container is smaller. This is a trial and error process. Take a look at the rulers on the working tabs and compare them to the rulers on the non-working tab.

 

[boblarson]

I know there must be some locking function, or anchor for the tab control,

Nope, there isn't. It all has to do with the size and placement of your subforms.

 

[KenHigg]

What do you mean when you say it jumps up the screen? Are you using a subform set to display continuous forms and when you display it it always starts at the first (top) record?

 

[bill33]

What do you mean when you say it jumps up the screen? Are you using a subform set to display continuous forms and when you display it it always starts at the first (top) record?

Basically, Imagine credit card info.

I have basic info: CC # name, address, etc in the main form (parent form)

Then I have used the Tab Control tool to put in 4 difffernt shops (Subforms places in the tabs). Lets call them JC Penny, Home Depot, PetSmart and Macys.

The JCPenny, PetSmart and Macys tabs all work well because there are not too many controls in these subforms. However, HomeDepot has a lot more fields needed, and when I click that tab, the screen jumps so that the parent fields, and the names on the tabs, are up on the screen and I have to scroll up inorder to see the important standard info that I wanted to be seen.

I tried moving the standard info to the form header, which does allow me to see it on every tab, but now the tabs themselves are jumping up the screen so that when I click the HomeDepot tab, it jumps up and now I cant see the other tabs unless I scroll up.

When you talk abou changing the control sizes, are you saying that I need to shorten the subform so that it fits a specific area?

 

[georgedwilkinson]

You must change the size of the container of the subforms that are giving you problems, along with the size of the tab control, as needed.

 

[bill33]

OH BTW: I should mention I am using Office 2003, not 2007.

 

[Banana]

Indeed.

The sizing of tab control and tabs' subforms was a trial and error in itself.

One semi-solution I've since used is to test only for one tab and see if everything displays correctly, then pass on the width of that subform to all other subforms, and the heigh & width of the subform container to all other containers.

 

[KenHigg]

I still confused. Sounds like the subform is simply to large for the container you're trying to put it in. Can you post a sample db - ?

 

[missinglinq]

This problem can also be caused if the tabbed control is too long to be viewed without scrolling and the first control on the errant tabbed page is situated low down on the page.

You might want to open the form the subform is based on and use this code

Private Sub Form_Current()
  FirstControlOnSubForm.SetFocus
End Sub

replacing FirstControlOnSubForm with the actual name of a control at he top of the form. That way focus should always go the top of the subform when it opens a record.

 

[bill33]

Thanks all, I utilized the idea given by Banana. It seems to be working so far.

Thanks again!