Conditional formatting does not work

[mdullni1 via AccessMonster.com]

I have read through dozens of posts on this forum about conditional
formatting, but cannot resolve my problem.

I have a continuous subform with txtAddress and chkSuppress. I want
txtAddress.forecolor set to red when chkSuppress is true. Using conditional
formatting on txtAddress, I have selected "Expression Is" and have tried:

[chkSuppress] = True
chkSuppress = True
[chkSuppress.value] = True
[chkSuppress] = -1
chkSuppress = -1
[chkSuppress.value] = -1
[me.chkSuppress] = True
me.chkSuppress = True
[me.chkSuppress.value] = True
True (to produce an always true expression)

Yes, I have selected black as the default format, and red as the conditional
format.

Nothing works (color never changes). Any ideas?

Thank you for reading my post. I hope you can help.

 

[John W. Vinson]

I have read through dozens of posts on this forum about conditional
formatting, but cannot resolve my problem.

I have a continuous subform with txtAddress and chkSuppress. I want
txtAddress.forecolor set to red when chkSuppress is true. Using conditional
formatting on txtAddress, I have selected "Expression Is" and have tried:

[chkSuppress] = True
chkSuppress = True
[chkSuppress.value] = True
[chkSuppress] = -1
chkSuppress = -1
[chkSuppress.value] = -1
[me.chkSuppress] = True
me.chkSuppress = True
[me.chkSuppress.value] = True
True (to produce an always true expression)

Yes, I have selected black as the default format, and red as the conditional
format.

Nothing works (color never changes). Any ideas?

Thank you for reading my post. I hope you can help.

What is the form's Recordsource - post the SQL please. More specifically,
which table or query field is the control named chkSuppress's Control Source?
Try using that fieldname rather than the name of the form control.

 

[mdullni1 via AccessMonster.com]

John,

Thank you for responding. I neglected to state in my post that at first I
tried using the field name. To be sure, I tried it again. I also tried 1=1
to create an always true condition. Neither produced a change in forecolor.

I am using Access 2003 SP3 with 2002-2003 file format (mdb). The subform
source is a select query agianst an ODBC linked SQLServer view.

It is like conditional formatting is not turned on. Is there a setting some
place to allow it to be used?

 

[John W. Vinson]

John,

Thank you for responding. I neglected to state in my post that at first I
tried using the field name. To be sure, I tried it again. I also tried 1=1
to create an always true condition. Neither produced a change in forecolor.

I am using Access 2003 SP3 with 2002-2003 file format (mdb). The subform
source is a select query agianst an ODBC linked SQLServer view.

It is like conditional formatting is not turned on. Is there a setting some
place to allow it to be used?

This is a new one to me!

Try deleting the form; compact the database; and recreate the form from
scratch. Maybe there's some sort of subtle corruption.