remove auto focus from subform

[icemonster]

hello. i have a tab that has a subform in it. my problem is whenever i load the form, the focus goes to the subform so the top of the tab is not visible, i have to scroll up just so that it would be. there a fix to this? thanks.

 

[vbaInet]

There's no fix per se. You just need to reduce the height of the page or tab, then the tab control. In that order.

 

[John Big Booty]

You could use the On Load event to set the focus to any control you desired.

 

[vbaInet]

Problem is setting focus to a control when dealing with tab controls doesn't always work. If the height of the page is just way to long, then it certainly wouldn't work. But if it was a reasonable height you might just be lucky.

 

[John Big Booty]

Fair point