Conditional Formatting and DCount (?)

  • Thread starter Thread starter croy
  • Start date Start date
C

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?
 
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.
 
Back
Top