ACCESS CONDITIONAL FORMATTING - ONE FIELD TO CHANGE COLOR UPON UPDATE OF OTHER FIELD

Experts,

I have a subform in datasheet view and I want field: LineNo to grey out if field: Submitted is checked.  I know I need to go to design view, click on LineNo field and go to conditional formatting and enter in a certain formula, but I cannot get the formula to work--I think I just need the proper syntax.  I've been trying: "Submitted"=True , but it is not working...?

Help!

stevenjoe
stevenjoeAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
use

Expression Is [Submitted]=True

or

Expression Is [Submitted]="True"

or

Expression Is [Submitted]=-1
0
 
rockiroadsCommented:
Conditional formatting is a right pain with datasheets

so u may wanna try this
http://www.lebans.com/conditionalformatting.htm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.