A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Tabbed Form / Number of Tabs per row



 
 
Thread Tools Display Modes
  #1  
Old October 11th, 2006, 08:35 PM posted to microsoft.public.access.forms
Tony
external usenet poster
 
Posts: 34
Default Tabbed Form / Number of Tabs per row

Hi All,

In Acc2K, is there a way to control how many tabs are on each line in a
multi-row tabbed form? I've got 14 tabs, 9 of which show up on the second
row with the balance on the first row. I'd like to rearrange this such that
there are 7 per row.

Any help is appreciated.

Thanks & Ciao


  #2  
Old October 11th, 2006, 09:06 PM posted to microsoft.public.access.forms
Niniel
external usenet poster
 
Posts: 582
Default Tabbed Form / Number of Tabs per row

I believe all you can do is to adjust the width of the tab control, and/or of
the tabs themselves so that in the end, you'll have an even 7/7 split.

"Tony" wrote:

Hi All,

In Acc2K, is there a way to control how many tabs are on each line in a
multi-row tabbed form? I've got 14 tabs, 9 of which show up on the second
row with the balance on the first row. I'd like to rearrange this such that
there are 7 per row.

Any help is appreciated.

Thanks & Ciao



  #3  
Old October 12th, 2006, 02:49 PM posted to microsoft.public.access.forms
Tony
external usenet poster
 
Posts: 34
Default Tabbed Form / Number of Tabs per row

Niniel,

Thanks for the response - good suggestions and ones I considered. However,
each tab has a subform which needs to be a specific width. If I resize the
tab control I won't have enough room to properly display the subforms.

Any other suggestions?

Thanks


"Niniel" wrote in message
...
I believe all you can do is to adjust the width of the tab control, and/or
of
the tabs themselves so that in the end, you'll have an even 7/7 split.

"Tony" wrote:

Hi All,

In Acc2K, is there a way to control how many tabs are on each line in a
multi-row tabbed form? I've got 14 tabs, 9 of which show up on the
second
row with the balance on the first row. I'd like to rearrange this such
that
there are 7 per row.

Any help is appreciated.

Thanks & Ciao





  #4  
Old October 12th, 2006, 03:22 PM posted to microsoft.public.access.forms
Niniel
external usenet poster
 
Posts: 582
Default Tabbed Form / Number of Tabs per row

Sorry, I guess I wasn't very clear - adjusting the width of the tab control
sets the width of the tab pages, so if you need a certain minimum size, you
obviously can't do that.
However, when I spoke of adjusting the width of the tabs I did not mean the
tab pages, but just the tabs you click on.
Their width can be adjusted as well, by going to your tab control property
sheet [the one where you set it to multi-row] and putting a value into a
field called "Tab Fixed Width". This will cheat Access' automatic tab
handling which will try to fill the first row first before putting any tabs
that didn't fit onto the next row. But if the tabs are just the right width,
Access has no choice but to split them the way you want.


"Tony" wrote:

Niniel,

Thanks for the response - good suggestions and ones I considered. However,
each tab has a subform which needs to be a specific width. If I resize the
tab control I won't have enough room to properly display the subforms.

Any other suggestions?

Thanks


  #5  
Old October 12th, 2006, 09:54 PM posted to microsoft.public.access.forms
Tony
external usenet poster
 
Posts: 34
Default Tabbed Form / Number of Tabs per row

Ah, now I see. I'll give that a shot and post back as to whether or not it
worked.

Thanks for the assistance.


"Niniel" wrote in message
...
Sorry, I guess I wasn't very clear - adjusting the width of the tab
control
sets the width of the tab pages, so if you need a certain minimum size,
you
obviously can't do that.
However, when I spoke of adjusting the width of the tabs I did not mean
the
tab pages, but just the tabs you click on.
Their width can be adjusted as well, by going to your tab control property
sheet [the one where you set it to multi-row] and putting a value into a
field called "Tab Fixed Width". This will cheat Access' automatic tab
handling which will try to fill the first row first before putting any
tabs
that didn't fit onto the next row. But if the tabs are just the right
width,
Access has no choice but to split them the way you want.


"Tony" wrote:

Niniel,

Thanks for the response - good suggestions and ones I considered.
However,
each tab has a subform which needs to be a specific width. If I resize
the
tab control I won't have enough room to properly display the subforms.

Any other suggestions?

Thanks




  #6  
Old October 12th, 2006, 10:03 PM posted to microsoft.public.access.forms
Tony
external usenet poster
 
Posts: 34
Default Tabbed Form / Number of Tabs per row

Gave it a shot and it worked, for the most part. Something I've always
noticed in Access is tripping me up. Even though I can set measurements to
4 decimal places, it doesn't always respect that and plops in something
close. Not sure why that is, but it ends up leaving just a tad of space
unused in each row. Not a big deal, but it's a bit annoying.

I'll keep tweaking and see if I can make it 'just right'. Thanks again for
the suggestion; this is the first time I've worked with tabbed forms and am
learning a lot. I appreciate the help.

Ciao

"Niniel" wrote in message
...
Sorry, I guess I wasn't very clear - adjusting the width of the tab
control
sets the width of the tab pages, so if you need a certain minimum size,
you
obviously can't do that.
However, when I spoke of adjusting the width of the tabs I did not mean
the
tab pages, but just the tabs you click on.
Their width can be adjusted as well, by going to your tab control property
sheet [the one where you set it to multi-row] and putting a value into a
field called "Tab Fixed Width". This will cheat Access' automatic tab
handling which will try to fill the first row first before putting any
tabs
that didn't fit onto the next row. But if the tabs are just the right
width,
Access has no choice but to split them the way you want.


"Tony" wrote:

Niniel,

Thanks for the response - good suggestions and ones I considered.
However,
each tab has a subform which needs to be a specific width. If I resize
the
tab control I won't have enough room to properly display the subforms.

Any other suggestions?

Thanks




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.