Conditinal Formating - continuous form - menu - Tickbox


B

Billp

Hi,
using the format menu I can select conditional formatting after selecting
the fields I wish to change format on when a tickbox (Yes no) is true.
The tickbox is [Has_Left].

In the condition 1, I choose "Expression Is"
In the right box I have
[Has_Left]= true.

Trouble is nothing happens.
I have selected red font - nothing happens
I have selected "disable" nothing happens

Please help with the expression
 
Ad

Advertisements

G

Gina Whipp

Billp,

I would first confirm the name of the field, not the control source and two
which do you want the font color to change. If you are trying to change the
font color of a tick box it won't happen. You need to select the field you
want to apply the color change to that is not a tick box.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
C

code46

example:

In Continuous Forms:

textbox/field= Overdue
chkBox= chkOver y/n

(on field Overdue) Expression Is [chkOver]=True
field backcolor, yellow or ...
(both True or -1 work)
---------------
sometimes I need to 'color' the checkBox itself.

I add a unbound textbox and position it behind the chkBox, call it txt1 or
something.
again on txt1:
Expression Is [chkbox]=true backcolor of txt1 is red.

everytime chkbox is true the field behind is red.

hope I made this understandable.
 
Ad

Advertisements

B

Billp

To All,
Thanks, every bit helped believe it or not.
The control, I had to Change its name to something else.
I did use an unbound box.
I also had a field hidden behind those I was wishing to control that had a
wrong property - it was set to not visible so was affecting the others.
And yes changing the true to -1 did work.
Actually both expressions worked after correcting naming and hidden
properties.
Once again I thank all.
Best regards
Bill


code46 said:
example:

In Continuous Forms:

textbox/field= Overdue
chkBox= chkOver y/n

(on field Overdue) Expression Is [chkOver]=True
field backcolor, yellow or ...
(both True or -1 work)
---------------
sometimes I need to 'color' the checkBox itself.

I add a unbound textbox and position it behind the chkBox, call it txt1 or
something.
again on txt1:
Expression Is [chkbox]=true backcolor of txt1 is red.

everytime chkbox is true the field behind is red.

hope I made this understandable.

Billp said:
Hi,
using the format menu I can select conditional formatting after selecting
the fields I wish to change format on when a tickbox (Yes no) is true.
The tickbox is [Has_Left].

In the condition 1, I choose "Expression Is"
In the right box I have
[Has_Left]= true.

Trouble is nothing happens.
I have selected red font - nothing happens
I have selected "disable" nothing happens

Please help with the expression
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top