467,925 Members | 1,880 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,925 developers. It's quick & easy.

conditional formatting

i've been trying to get conditional formatting to work via a tick box. this
is on a form
i have a text box that i'd like to have the background colour change based
on a tick box.
the text box would have white background until such time as the tick box was
ticked then the back ground of the text box would turn red.

can someone direct me as to how to accomplish this

Nov 13 '05 #1
  • viewed: 5127
Share:
4 Replies
Check boxes do not have a BackColor property to set.

On a report where you don't need to change the value, you can use a text box
that looks like a check box. Details in:
Check boxes on reports
at:
http://members.iinet.net.au/~allenbrowne/ser-52.html

--
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.

"mugen" <z@brainless.net> wrote in message
news:35*************@individual.net...
i've been trying to get conditional formatting to work via a tick box.
this is on a form
i have a text box that i'd like to have the background colour change based
on a tick box.
the text box would have white background until such time as the tick box
was ticked then the back ground of the text box would turn red.

can someone direct me as to how to accomplish this

Nov 13 '05 #2
thanks..

it's not the back colour of the check box i want to change.
i'd like a text box (that is showing different information) in the same
form.. to have it's background change colour when the checkbox it ticked..
is this possibble
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
Check boxes do not have a BackColor property to set.

On a report where you don't need to change the value, you can use a text
box that looks like a check box. Details in:
Check boxes on reports
at:
http://members.iinet.net.au/~allenbrowne/ser-52.html

--
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.

"mugen" <z@brainless.net> wrote in message
news:35*************@individual.net...
i've been trying to get conditional formatting to work via a tick box.
this is on a form
i have a text box that i'd like to have the background colour change
based on a tick box.
the text box would have white background until such time as the tick box
was ticked then the back ground of the text box would turn red.

can someone direct me as to how to accomplish this


Nov 13 '05 #3
Sorry, I didn't read your question properly.

1. Open your form in design view, and select the text box to be formatted.

2. Choose Conditional Formatting on the Format menu, and set Condition 1 to:
Expression Is ... [xxx] = True
replacing "xxx" with the name of your check box.

--
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.

"mugen" <z@brainless.net> wrote in message
news:35*************@individual.net...
thanks..

it's not the back colour of the check box i want to change.
i'd like a text box (that is showing different information) in the same
form.. to have it's background change colour when the checkbox it ticked..
is this possibble

Nov 13 '05 #4
thanks very much.. that worked a treat
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
Sorry, I didn't read your question properly.

1. Open your form in design view, and select the text box to be formatted.

2. Choose Conditional Formatting on the Format menu, and set Condition 1
to:
Expression Is ... [xxx] = True
replacing "xxx" with the name of your check box.

--
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.

"mugen" <z@brainless.net> wrote in message
news:35*************@individual.net...
thanks..

it's not the back colour of the check box i want to change.
i'd like a text box (that is showing different information) in the same
form.. to have it's background change colour when the checkbox it
ticked..
is this possibble


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Bradley | last post: by
8 posts views Thread by Dimitri Furman | last post: by
2 posts views Thread by Von Bailey | last post: by
5 posts views Thread by Andrew Chanter | last post: by
1 post views Thread by GGerard | last post: by
2 posts views Thread by Filips Benoit | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.