By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,122 Members | 1,641 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,122 IT Pros & Developers. It's quick & easy.

Hide/Show Tab Control on Main Form

P: 0
I have a main form with a tab control (two subforms). There are memo fields above the tab control with "getFocus" set so the entire text is displayed when user clicks inside the fields. The tab control is right below the memo field to save space (the form must be designed that way). The problem is the memo text will not fully display because the below tab control is in the way. I tried using the Access feature "Move to the Front" for the memo fields, but it does not work. I figured if I could show/hide the tab control (maybe through a check box) that would solve the problem. What VBA code do I use with the check box to do that?
Apr 11 '17 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,107
I'm not sure what you are trying to do. It sounds like you to trying to hide a TextBox control behind a TabControl, and then fully show the TextBox control when it gets Focus. It also sounds like it's not working for you.

TabControls have a few quirks. One of them is that the Tabs portion gets drawn no matter what is going on. Which I'm guessing is what is messing with you. My suggestion would be to just leave the TabControl alone and use the Built-In Zoom function in Access. From any TextBox you can type {Shift}+{F2} and it will open up the ZoomBox. Another thing you can do is to is in the DoubleClick Event of the TextBox, you can put the following code:
Expand|Select|Wrap|Line Numbers
  1. RunCommand acCmdZoomBox
Then when you double-click your Note TextBox, it will Zoom in.

Another option is to create a Button right next to your TextBox and add some code like the following:
Expand|Select|Wrap|Line Numbers
  1. Me.[Name of TextBox].SetFocus
  2. RunCommand acCmdZoomBox
Then when you click on the button, it will zoom the TextBox
Apr 11 '17 #2

P: 0
Thanks for your assistance
Apr 12 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.