Tab 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


"BG44" wrote:

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.

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

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.


"Linq Adams via AccessMonster.com" wrote:

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

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.

"magicdds" wrote:

Try making the form smaller in design view and when opening the form, have it
maximize.

Hope this helps.

Mark


"BG44" wrote:

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.

BG44 wrote:
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.

--
Rick 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

"Rick Brandt" wrote:

BG44 wrote:
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

BG44 wrote:
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.

--
Rick 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.

"Rick Brandt" wrote:

BG44 wrote:
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

BG44 wrote:
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com