 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Tab Controls Disappear from sight in Form View
I have a database with 5 tabs, 4 have subforms, linked to main form via a user ID field that automatically fills in on all subforms when the ID is entered on the main form. The problem is that in form view, after entering a new ID, when I click on any of the other tabs, the top of the details section with the tabs disappears and I see only the subform from the User ID downward. I really would like to have the tabs always be viewable, no matter which tab control I happen to be working in. Thank you. Try making the form smaller in design view and when opening the form, have it maximize. Hope this helps. Mark > I have a database with 5 tabs, 4 have subforms, linked to main form via a > user ID field that automatically fills in on all subforms when the ID is [quoted text clipped - 3 lines] > downward. I really would like to have the tabs always be viewable, no matter > which tab control I happen to be working in. Thank you. Usually this behavior is the result of having the control that first receives focus being located low on the tabbed page, causing Access to automatically scroll down.  SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Thank you, I tried that but no luck. The main form shows the detail section properly when no tabs and subforms are inserted but as soon as I put them back, the tabs along the top are not viewable when opening the form in Form view. > Usually this behavior is the result of having the control that first receives > focus being located low on the tabbed page, causing Access to automatically > scroll down. Thank you, I tried that but no luck. The main form shows the detail section properly when no tabs and subforms are inserted but as soon as I put them back, the tabs along the top are not viewable when opening the form in Form view. > Try making the form smaller in design view and when opening the form, have it > maximize. [quoted text clipped - 10 lines] > > downward. I really would like to have the tabs always be viewable, no matter > > which tab control I happen to be working in. Thank you. > Thank you, I tried that but no luck. The main form shows the detail > section properly when no tabs and subforms are inserted but as soon > as I put them back, the tabs along the top are not viewable when > opening the form in Form view. If your tabs have subforms on them it means your subform *controls* are not tall enough to show the entire subform within them. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Ok. Sorry but I don't understand what you mean. I am trying to figure this out by using a Microsoft guide but obviously I am missing something. Or many somethings > > Thank you, I tried that but no luck. The main form shows the detail > > section properly when no tabs and subforms are inserted but as soon [quoted text clipped - 3 lines] > If your tabs have subforms on them it means your subform *controls* are not > tall enough to show the entire subform within them. > Ok. Sorry but I don't understand what you mean. I am trying to > figure this out by using a Microsoft guide but obviously I am missing > something. Or many somethings Example: If your subform control (on a TabPage) is 2 inches tall and the form shown within it is 2.1 inches tall then I have seen this behavior where the Tabs scroll up and out of view. Making the subform control taller solves the problem. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com I don't know. I try and try but cannot get it to work. The form is fine until I add another tab with subform - as soon as I do, the tabs disappear. All the subforms I try affect the main form the same way. Thanks for the responses though. > > Ok. Sorry but I don't understand what you mean. I am trying to > > figure this out by using a Microsoft guide but obviously I am missing [quoted text clipped - 6 lines] > scroll up and out of view. Making the subform control taller solves the > problem. > I don't know. I try and try but cannot get it to work. The form is > fine until I add another tab with subform - as soon as I do, the tabs > disappear. All the subforms I try affect the main form the same way. > Thanks for the responses though. But...did you try simply making the subform control taller? As a test make it a LOT taller and see what happens. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com I really don't unsderstand what you mean by subform control. If I click on the box in the upper left corner and display the properties of the subform, on format I see form width, but no height. I cannot find subform control in my book. Thank you though for your help. > > I don't know. I try and try but cannot get it to work. The form is > > fine until I add another tab with subform - as soon as I do, the tabs [quoted text clipped - 3 lines] > But...did you try simply making the subform control taller? As a test make > it a LOT taller and see what happens. > I really don't unsderstand what you mean by subform control. If I > click on the box in the upper left corner and display the properties > of the subform, on format I see form width, but no height. I cannot > find subform control in my book. Thank you though for your help. The rectangular area you see on your main form where the subform is displayed is the subform control. It is the container used to contain and display the form you are using as a subform and it can be sized just like any other control by grabbing its edge with the mouse and dragging. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com The subform is quite large already as it is a form that is 12x22. The thing that happens is this: on my subform are fields that get filled in automatically from the main form (user id, accession #.) When I first open the form, the tabs are visible, I can tab through them and they stay visible. As soon as I enter the user Id and Accession # in the main form and click on the next subform, the tabs disappear and the focus is on the user ID in the subform, with clicking mouse cursor. I don't know how to make those tabs show up and still have the user id, etc. fill in properly. I don't have anywhere else to set the focus as the only thing at the top would be a label displaying the database name, and I read, perhaps incorrectly, you can't make that a focus point. Thank you for your kind responses. > > I really don't unsderstand what you mean by subform control. If I > > click on the box in the upper left corner and display the properties [quoted text clipped - 5 lines] > display the form you are using as a subform and it can be sized just like > any other control by grabbing its edge with the mouse and dragging. > The subform is quite large already as it is a form that is 12x22. The > thing that happens is this: on my subform are fields that get filled [quoted text clipped - 8 lines] > the database name, and I read, perhaps incorrectly, you can't make > that a focus point. Thank you for your kind responses. I don't know how to make what I am saying any clearer. I don't believe the size of the container being used to display your subform (the subform control) is large enough to display ALL of the form being used as a subform at one time. If it were large enough it would not matter where you set focus in the subform. The fact that setting focus to a certain control causes the tab-scrolling to occur is evidence that the form is larger than the control. Obviously when things are correct you should be able to set focus anywhere you like. Last try... Even if it looks ridiculous, (as a test only) make your subform control a LOT bigger in both height and width to see if the problem goes away. If it doesn't then I am on the wrong track. If it does then you can experiment with the size to see what "reasonable" size works properly. You might even be able to just use the Auto-Size option in the format menu. That should make the subform control just large enough to contain the form it is displaying. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com I made everything huge yesterday and that still didn't work so thanks for your time. > > The subform is quite large already as it is a form that is 12x22. The > > thing that happens is this: on my subform are fields that get filled [quoted text clipped - 29 lines] > make the subform control just large enough to contain the form it is > displaying. >> The subform is quite large already as it is a form that is 12x22. The Since a form is limited in size to 22 inches for both height and width then by definition it is impossible for a subform control to completely display a subform that has a 22 inch dimension on a TabControl since the TabControl and main form must consume some space of their own. Bottom line is that your subform must be made smaller. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com I think I now see what you were saying. I was not making the underneath layer big enough - I was on the wrong section of the subform. I believe I have the right track. Thanks again for all your help. Now on to stopping the records from scrolling when I use the mouse scroll. I am sure there will be an answer in this forum somewhere for that. It must take a bit of patience for all you experts to drag novices through things they aren't trained or paid to do. Thanks again. > The subform is quite large already as it is a form that is 12x22. The thing > that happens is this: on my subform are fields that get filled in [quoted text clipped - 17 lines] > > display the form you are using as a subform and it can be sized just like > > any other control by grabbing its edge with the mouse and dragging. > I think I now see what you were saying. I was not making the > underneath layer big enough - I was on the wrong section of the [quoted text clipped - 4 lines] > experts to drag novices through things they aren't trained or paid to > do. Thanks again. That behavior was finally corrected in Access 2007. For prior versions Steven Lebans has a DLL and accompanying VBA code you can use to turn that behavior off. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.