Conditional Formatting Question

[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

 

[Allen Browne]

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

 

[Rick B]

A true/false field will contain "-1" or "0".

 

[Rick B]

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

A true/false field will contain "-1" or "0".

--
Rick B

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

 

[Guest]

Thanks. It worked