Conditional Formatting and DCount (?)

[croy]

Should the following statement work in Conditional
Formatting for a field?

DCount("Kept","tblCatch","IvDetId=" & Me![txtIvDetId])>0

I copied the syntax from a form module, so maybe it needs to
be tweaked for use in the Conditional Formatting window?

 

[Guest]

Yes, but only if txtIvDetId is a number. If text, try changing it to:

DCount("[Kept]","tblCatch","[IvDetId]='" & Me![txtIvDetId] & "'")>0

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[croy]

Yes, but only if txtIvDetId is a number.

Yup, plain-Jane Autonumber field.

But still the formatting doesn't kick in. %-<