Access Form Conditional Formatting Expression

[mrmmickle1]

I currently have a form called frmReviewData.



The form has data from a table called tblCDT. I have a field in this table called flag that is a "Yes/No" data type. I am trying to use the form conditional formatting to highlight the field on my form red with white font if the FLAG Field = TRUE....


So for the field RPT_NAME I want in the form for it to turn red with white text if [tblCDT]![Flag] = TRUE ..... however I can't seem to get this to work. I have tried using these expressions:



[tblCDT]![Flag] = TRUE
[tblCDT]![Flag] = "TRUE"
[tblCDT]![Flag] = 'TRUE'
[tblCDT]![Flag] = -1

**Note: If i conditionally format the field FLAG Field Value equal to True it works fine.... just no luck on other fields

What am I doing incorrectly? Any help would be much appreciated. Ideally, I would like to do this for multiple fields so the whole record is red with white font but, I can't even get it to work with one record

[mrmmickle1]

Apparently I forgot to change the font and background formatting so the conditional formatting appeared not to be working...... duh!!!


End Expression is [Flag]=True