Conditinal Formating - continuous form - menu - Tickbox

[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

 

[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

 

[Linq Adams via AccessMonster.com]

Replace

[Has_Left]= true.


with

[Has_Left] = -1

and see what happens.

 

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

 

[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

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.

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