Conditional Formatting and DCount (?)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

croy - 16 Nov 2007 18:35 GMT

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?

Signature

Thanks,
croy

Reply to this Message

boblarson - 16 Nov 2007 19:54 GMT

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

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

Signature

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.

> Should the following statement work in Conditional
> Formatting for a field?
[quoted text clipped - 3 lines]
> I copied the syntax from a form module, so maybe it needs to
> be tweaked for use in the Conditional Formatting window?

Reply to this Message

croy - 19 Nov 2007 16:36 GMT

>Yes, but only if txtIvDetId is a number.

Yup, plain-Jane Autonumber field.

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

Signature

croy

Reply to this Message