conditional formatting split form datasheet not working

[svdoerga]

I am trying to get certain rows in the datasheet view to get a green highlight, depending on a checkbox. Working with access 2007

In design view I select all the textboxes and set condition 1 of the the conditional formatting with a different font and cell color and "expression is" like this:

[Forms]![Main Form]![chk_CaseClosed]=True

"Main Form" is the name of the form and "chk_CaseClosed" is the name of the checkbox that determines whether a row should be green.

This doesn't work. Can anyone tell me what I'm doing wrong?

 

[TheAceMan1]

How are ya svdoerga . . .

Try:

[blue][chk_CaseClosed]=True[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[svdoerga]

Hey TheAceMan1,

Thanks for your reply. "[chk_CaseClosed]=True" doesn't work either. I have tried a few simple conditional formatting settings, that use the cell value. Those work just fine. That makes me think there's something wrong with the expression.

Any other possibilities?

 

[TheAceMan1]

svdoerga . . .

Are you talking Excel here?

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[svdoerga]

Haha no not Excel, Access 2007. I guess 'cell' was a bad word choice. I had the datasheet in mind when I typed that. Of course I mean field value.

 

[TheAceMan1]

svdoerga . . .

Check the [blue]name property[/blue] of chk_CaseClosed, in code this is the name thats used. If its the same then try constructing another form.



See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[svdoerga]

I haven't been able to get it working, but it doesn't matter now. The requirement to have conditional formatting has been dropped for the db-app I'm making.

Thanks for your replies TheAceMan1.