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  

Tab control form



 
 
Thread Tools Display Modes
  #1  
Old December 7th, 2006, 09:43 PM posted to microsoft.public.access.forms
sandrao
external usenet poster
 
Posts: 46
Default Tab control form

Is there any way to change the background color on a Tab Control form. The
default color is some sort of gray color. I would like to the Tab control
form along with its tabs blend in with the Design view form that it in
embetted in.
There seems to be nothing in its properities that allows for color change.

Ads
  #2  
Old December 8th, 2006, 12:54 AM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Tab control form

Check Google.com for Tab Control Color Lebans ... I seem to recall S. Lebans
has something that can handle that.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"sandrao" wrote in message
...
Is there any way to change the background color on a Tab Control form.
The
default color is some sort of gray color. I would like to the Tab
control
form along with its tabs blend in with the Design view form that it in
embetted in.
There seems to be nothing in its properities that allows for color change.



  #3  
Old December 8th, 2006, 05:01 AM posted to microsoft.public.access.forms
tina
external usenet poster
 
Posts: 1,997
Default Tab control form

personally, i love the TabControl and use it a LOT in my databases' forms,
but i hate the way it looks. so i set the control's BackStyle property to
Transparent, and the Style property to None (no tabs or buttons). so my
users don't "see" the tab control at all, only the objects i place on each
page of the control. in order to navigate between pages, i use an option
group with toggle buttons - one button for each page.

hth


"sandrao" wrote in message
...
Is there any way to change the background color on a Tab Control form.

The
default color is some sort of gray color. I would like to the Tab

control
form along with its tabs blend in with the Design view form that it in
embetted in.
There seems to be nothing in its properities that allows for color change.



  #4  
Old December 19th, 2006, 08:20 PM posted to microsoft.public.access.forms
cprav
external usenet poster
 
Posts: 39
Default Tab control form

Hi tina,

I like this suggestion, but I'm wondering what I do to the toggle buttons to
make them go to each page - how do I set them up? I'm just learning access,
but always seem to want to do more difficult things!

Thanks!

"tina" wrote:

personally, i love the TabControl and use it a LOT in my databases' forms,
but i hate the way it looks. so i set the control's BackStyle property to
Transparent, and the Style property to None (no tabs or buttons). so my
users don't "see" the tab control at all, only the objects i place on each
page of the control. in order to navigate between pages, i use an option
group with toggle buttons - one button for each page.

hth


"sandrao" wrote in message
...
Is there any way to change the background color on a Tab Control form.

The
default color is some sort of gray color. I would like to the Tab

control
form along with its tabs blend in with the Design view form that it in
embetted in.
There seems to be nothing in its properities that allows for color change.




  #5  
Old December 20th, 2006, 06:27 AM posted to microsoft.public.access.forms
tina
external usenet poster
 
Posts: 1,997
Default Tab control form

well, it's easy enough, but you need a background understanding of the tab
control and option group first, so bear with me a minute and i'll try to
explain them so it makes sense:

the *pages* in a tab control have no Value property, but they do have a
PageIndex property which reflects the "order" of the pages within the tab
control. the index is zero-based, so the first page has a PageIndex of zero
(0), the second page's PageIndex is 1, the third page is 2, etc.

clear so far? okay, now, the tab control *does* have a Value property. the
value of a tab control is equal to the PageIndex of the currently active tab
control page. for instance, if page 3 of the tab control is "showing", then
the value of the tab control is 2 (remember that zero-based index, explained
above).

to move from one page to another in the tab control, programmatically, you
set the value of the tab control = to the PageIndex of the page you want to
move to. for instance, to move to the third page in the tab control, use the
following code, as

Me.TabCtrlName = 2

alright then, let's look at how an option group works. here again, an option
group control has a Value property. the option buttons (or checkboxes, or
toggle buttons) within the group do *not* have a Value property, but they
*do* have an OptionValue property (the difference here is that you can set
the OptionValue property of each option button to whatever you want). the
value of the option group control is equal to the OptionValue property of
the option button that the user selects. for instance, if the second option
button has an OptionValue property of 250 (remember, you can set the
property of each button to whatever you want), and that button is selected,
then the Value of the option group control = 250.

okay, let's bring it all together so that you can use an option group to
navigate between tab control pages. the scenario: create a tab control
named TabCtrl0, with three pages (the PageIndex property of the respective
pages are 0, 1, and 2). create an option group named grpChoice, with three
toggle buttons. when you click the first button, you want to see the first
tab control page, so set the OptionValue property of the button to zero (0);
you want the second button to take you to the second page, so set the second
button's OptionValue property to 1; and of course the third button's
property will be set to 2, to move to the third tab control page.

after setting up the controls and their properties as described above, add
the following code to the *Click event procedure of grpChoice*, as

Me!TabCtrl0 = Me!grpChoice

yes, it really is that simple, once you understand how the tab and option
group controls work, and how to use them together.

hth


"cprav" wrote in message
...
Hi tina,

I like this suggestion, but I'm wondering what I do to the toggle buttons

to
make them go to each page - how do I set them up? I'm just learning

access,
but always seem to want to do more difficult things!

Thanks!

"tina" wrote:

personally, i love the TabControl and use it a LOT in my databases'

forms,
but i hate the way it looks. so i set the control's BackStyle property

to
Transparent, and the Style property to None (no tabs or buttons). so my
users don't "see" the tab control at all, only the objects i place on

each
page of the control. in order to navigate between pages, i use an option
group with toggle buttons - one button for each page.

hth


"sandrao" wrote in message
...
Is there any way to change the background color on a Tab Control form.

The
default color is some sort of gray color. I would like to the Tab

control
form along with its tabs blend in with the Design view form that it

in
embetted in.
There seems to be nothing in its properities that allows for color

change.






  #6  
Old December 20th, 2006, 01:40 PM posted to microsoft.public.access.forms
cprav
external usenet poster
 
Posts: 39
Default Tab control form

Tina,

Thank you so much! Of course, it worked! I had no doubts about that,
although I was starting to wonder when it just wouldn't work - until I
realized I'd made a typo!

I appreciate your quick response - and also the thoroughness(??) of it. I
really appreciated the background info you supplied instead of just giving me
the code at the end. It helped me understand it and perhaps use the
information in different ways in the future. I spent a lot of time in these
forums and this is the best reponse on any topic I have received.

Thanks again!

Cprav.

"tina" wrote:

well, it's easy enough, but you need a background understanding of the tab
control and option group first, so bear with me a minute and i'll try to
explain them so it makes sense:

the *pages* in a tab control have no Value property, but they do have a
PageIndex property which reflects the "order" of the pages within the tab
control. the index is zero-based, so the first page has a PageIndex of zero
(0), the second page's PageIndex is 1, the third page is 2, etc.

clear so far? okay, now, the tab control *does* have a Value property. the
value of a tab control is equal to the PageIndex of the currently active tab
control page. for instance, if page 3 of the tab control is "showing", then
the value of the tab control is 2 (remember that zero-based index, explained
above).

to move from one page to another in the tab control, programmatically, you
set the value of the tab control = to the PageIndex of the page you want to
move to. for instance, to move to the third page in the tab control, use the
following code, as

Me.TabCtrlName = 2

alright then, let's look at how an option group works. here again, an option
group control has a Value property. the option buttons (or checkboxes, or
toggle buttons) within the group do *not* have a Value property, but they
*do* have an OptionValue property (the difference here is that you can set
the OptionValue property of each option button to whatever you want). the
value of the option group control is equal to the OptionValue property of
the option button that the user selects. for instance, if the second option
button has an OptionValue property of 250 (remember, you can set the
property of each button to whatever you want), and that button is selected,
then the Value of the option group control = 250.

okay, let's bring it all together so that you can use an option group to
navigate between tab control pages. the scenario: create a tab control
named TabCtrl0, with three pages (the PageIndex property of the respective
pages are 0, 1, and 2). create an option group named grpChoice, with three
toggle buttons. when you click the first button, you want to see the first
tab control page, so set the OptionValue property of the button to zero (0);
you want the second button to take you to the second page, so set the second
button's OptionValue property to 1; and of course the third button's
property will be set to 2, to move to the third tab control page.

after setting up the controls and their properties as described above, add
the following code to the *Click event procedure of grpChoice*, as

Me!TabCtrl0 = Me!grpChoice

yes, it really is that simple, once you understand how the tab and option
group controls work, and how to use them together.

hth


"cprav" wrote in message
...
Hi tina,

I like this suggestion, but I'm wondering what I do to the toggle buttons

to
make them go to each page - how do I set them up? I'm just learning

access,
but always seem to want to do more difficult things!

Thanks!

"tina" wrote:

personally, i love the TabControl and use it a LOT in my databases'

forms,
but i hate the way it looks. so i set the control's BackStyle property

to
Transparent, and the Style property to None (no tabs or buttons). so my
users don't "see" the tab control at all, only the objects i place on

each
page of the control. in order to navigate between pages, i use an option
group with toggle buttons - one button for each page.

hth


"sandrao" wrote in message
...
Is there any way to change the background color on a Tab Control form.
The
default color is some sort of gray color. I would like to the Tab
control
form along with its tabs blend in with the Design view form that it

in
embetted in.
There seems to be nothing in its properities that allows for color

change.







  #7  
Old December 20th, 2006, 02:47 PM posted to microsoft.public.access.forms
tina
external usenet poster
 
Posts: 1,997
Default Tab control form

you're very welcome, and thank *you*, too.


"cprav" wrote in message
...
Tina,

Thank you so much! Of course, it worked! I had no doubts about that,
although I was starting to wonder when it just wouldn't work - until I
realized I'd made a typo!

I appreciate your quick response - and also the thoroughness(??) of it. I
really appreciated the background info you supplied instead of just giving

me
the code at the end. It helped me understand it and perhaps use the
information in different ways in the future. I spent a lot of time in

these
forums and this is the best reponse on any topic I have received.

Thanks again!

Cprav.

"tina" wrote:

well, it's easy enough, but you need a background understanding of the

tab
control and option group first, so bear with me a minute and i'll try to
explain them so it makes sense:

the *pages* in a tab control have no Value property, but they do have a
PageIndex property which reflects the "order" of the pages within the

tab
control. the index is zero-based, so the first page has a PageIndex of

zero
(0), the second page's PageIndex is 1, the third page is 2, etc.

clear so far? okay, now, the tab control *does* have a Value property.

the
value of a tab control is equal to the PageIndex of the currently active

tab
control page. for instance, if page 3 of the tab control is "showing",

then
the value of the tab control is 2 (remember that zero-based index,

explained
above).

to move from one page to another in the tab control, programmatically,

you
set the value of the tab control = to the PageIndex of the page you want

to
move to. for instance, to move to the third page in the tab control, use

the
following code, as

Me.TabCtrlName = 2

alright then, let's look at how an option group works. here again, an

option
group control has a Value property. the option buttons (or checkboxes,

or
toggle buttons) within the group do *not* have a Value property, but

they
*do* have an OptionValue property (the difference here is that you can

set
the OptionValue property of each option button to whatever you want).

the
value of the option group control is equal to the OptionValue property

of
the option button that the user selects. for instance, if the second

option
button has an OptionValue property of 250 (remember, you can set the
property of each button to whatever you want), and that button is

selected,
then the Value of the option group control = 250.

okay, let's bring it all together so that you can use an option group to
navigate between tab control pages. the scenario: create a tab control
named TabCtrl0, with three pages (the PageIndex property of the

respective
pages are 0, 1, and 2). create an option group named grpChoice, with

three
toggle buttons. when you click the first button, you want to see the

first
tab control page, so set the OptionValue property of the button to zero

(0);
you want the second button to take you to the second page, so set the

second
button's OptionValue property to 1; and of course the third button's
property will be set to 2, to move to the third tab control page.

after setting up the controls and their properties as described above,

add
the following code to the *Click event procedure of grpChoice*, as

Me!TabCtrl0 = Me!grpChoice

yes, it really is that simple, once you understand how the tab and

option
group controls work, and how to use them together.

hth


"cprav" wrote in message
...
Hi tina,

I like this suggestion, but I'm wondering what I do to the toggle

buttons
to
make them go to each page - how do I set them up? I'm just learning

access,
but always seem to want to do more difficult things!

Thanks!

"tina" wrote:

personally, i love the TabControl and use it a LOT in my databases'

forms,
but i hate the way it looks. so i set the control's BackStyle

property
to
Transparent, and the Style property to None (no tabs or buttons). so

my
users don't "see" the tab control at all, only the objects i place

on
each
page of the control. in order to navigate between pages, i use an

option
group with toggle buttons - one button for each page.

hth


"sandrao" wrote in message
...
Is there any way to change the background color on a Tab Control

form.
The
default color is some sort of gray color. I would like to the

Tab
control
form along with its tabs blend in with the Design view form that

it
in
embetted in.
There seems to be nothing in its properities that allows for color

change.









 




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 05:27 PM.


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