Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / November 2007

Tip: Looking for answers? Try searching our database.

Relative to a TAB Control I cannot 'send back' List Box and Subfor

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ThomasAJ - 17 Nov 2007 22:56 GMT
Other controls get hidden when I 'Bring To Front' the Tab control.

Even if I Send Back the List and Subform they stay in front. Is this normal?
Can code have more control.

Signature

Regards
Tom

Allen Browne - 18 Nov 2007 06:04 GMT
Controls can be either:
a) on the form, or
b) in one of the pages of the tab control.

From your description, it sounds like you have the controls sitting on the
form, when you want them in the tab control.

To change them:
1. Open the form in design view.
2. Select the controls that should be in page 1 of the tab control.
3. Cut them to clipboard (Ctrl+X.)
4. Click the tab page (i.e. click on the actual tab at the top of the tab
control.
5. Paste (Ctrl+V.)

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Other controls get hidden when I 'Bring To Front' the Tab control.
>
> Even if I Send Back the List and Subform they stay in front. Is this
> normal?
> Can code have more control.
ThomasAJ - 18 Nov 2007 06:31 GMT
Thanks Allen

However for various reasons I really do want to 'hide' ALL the controls on
the form 'behind' the tab control and I cannot do it for these two.

Picture a form approx 10cm x 10cm in size.
The top half has controls (full of them).
The bottom half has a Tab Control with 5 pages. Each page has lots of
controls.
What I want to do is when page5 tab is clicked I want to resize and
reposition the Tab Control to fill up almost all the form. The reason is that
page5 has (I want it to have if I can) lots of large controls that cannot fit
into page5 as it currently stands.
In other words have a large Tab control ONLY when page5 is in use. Also I do
not want to create another page as the page5 controls are very much related.
Maybe there is a better way of handling this design objective?
I would like to NOT create another form.

Signature

Regards
Tom

> Controls can be either:
> a) on the form, or
[quoted text clipped - 16 lines]
> > normal?
> > Can code have more control.
Allen Browne - 18 Nov 2007 06:41 GMT
If necessary, you can hide the controls you want to get rid of just by
setting the Visible property to No.

Resizing the tab control is not as easy as it sounds. Before you can shrink
its Width or Height, you must move/shink any controls left/up so they do not
occupy the space you want to shink. If you have control grouping (such as
option buttons in an option group on the tab page), it gets even more messy.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks Allen
>
[quoted text clipped - 39 lines]
>> > normal?
>> > Can code have more control.
 
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.