By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

How to use expression in conditional formatting?

P: n/a
I have a subform datasheet in which I want to bold the text of a field if
another field in the datasheet meets certain criteria. I think I want to
(select the field in question and) use something like:

Format >> Conditional Formatting >> Condition1 >> Expression Is = "If
Me!Entity_ID > 0"

But I'm not sure what syntax to use in the "Expression Is" window in the
Conditional Formatting dialog (the above example does not work)

-- is there a better way to do this in code? Do I need to reference a
function?

thx!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Deko,
I think just Me!Entity_ID > 0 will do (without if and without the quotes)

--
Hope this helps
Arno R
"deko" <dj****@hotmail.com> schreef in bericht
news:r0*****************@newssvr29.news.prodigy.co m...
I have a subform datasheet in which I want to bold the text of a field if
another field in the datasheet meets certain criteria. I think I want to
(select the field in question and) use something like:

Format >> Conditional Formatting >> Condition1 >> Expression Is = "If
Me!Entity_ID > 0"

But I'm not sure what syntax to use in the "Expression Is" window in the
Conditional Formatting dialog (the above example does not work)

-- is there a better way to do this in code? Do I need to reference a
function?

thx!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.