Conditional Formatting Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I have a subform on which the font color of the records is Red. One of the
fields on the form is named Complete which is a check box. When a record is
checked as completed, I wnat to change the records color to blue.

I opened the conditional formatting menu and I put in the following
expression:

[Forms]![sbfrmWarrantyWODetails]![completed]="1"

When I test it, nothing happens.

What am I doing wrong?

Thanks
Brennan
 
A subform is not open in its own right, i.e. it is not part of the forms
collection.

If the Completed box is on the same form, it should work with just:
Completed = -1

Note that Access uses -1 as the value for True, not 1, (and especially not 1
as a string.)
 
Allen made a good point. The " quotations would indicate a string, not a
number. I should have left those out of my response.

--
Rick B



Rick B said:
A true/false field will contain "-1" or "0".

--
Rick B



Brennan said:
Hello:

I have a subform on which the font color of the records is Red. One of the
fields on the form is named Complete which is a check box. When a
Click to expand...
record
is
checked as completed, I wnat to change the records color to blue.

I opened the conditional formatting menu and I put in the following
expression:

[Forms]![sbfrmWarrantyWODetails]![completed]="1"

When I test it, nothing happens.

What am I doing wrong?

Thanks
Brennan
Click to expand...
Click to expand...
 
Back
Top