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

conditional formatting

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.