tabbed form display problem

[tizwaz]

I have a form with a tab control on it. In design view it looks fine with the top of the tab control at the top of the detail section.However when I go into form view I have to scroll up to see the tabs as they are hidden. I don't want people to have to do this. Is there something I can do so that it opens with the tabs in view?

 

[Savil]

Make the detail section as short as possible, if you don't need form or page headers get rid of them.

 

[tizwaz]

Thanks I've tried that but the part of the form with the tabs on it is still hidden when you open it.

 

[Savil]

If all the detail section in design view is visible in form view and the tab control is on the detail section then I cannot think of a reason why this is happening.

May I suggest you re-post the question as people will think it has been answered by the number of replies.

Savil

 

[ZmrAbdulla]

Hi,
Is there any control that gets focus on open event of the form? If yes, where is the location of it?
Try
Private Sub Form_Load()
Me.TabCtlName.Pages(0).SetFocus
End Sub

regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

 

[RoyVidar]

OK - the detail section is fitted to the tab, what about the form footer? That will "steal" as much space as you've assigned to it, "shrinking" the space available to the detail section, and often behave like you say.

Roy-Vidar

 

[tizwaz]

Thanks to everyone - The code on the OnLoad event has done the trick

 

[ZmrAbdulla]

Hi, tizwaz
Although it is working, you should check the Footer is not too large to capture detail section's space as RoyVidar said
regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

 

[davecarson]

I get a compile error when I try this same thing

error: Method or data membr not found

Private Sub Form_Load()
Me.TabCtlName.Pages(0).SetFocus
End Sub

it hilights .TabCtlName.Pages(0).SetFocus

I am using Access 2002

 

[PHV]

This code must be in the Load event procedure of a Form hosting a TabControl object named TabCtlName.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244