conditional formatting errors

[jamesgonzo]

I have a form with some expressions and conditional formatting. I've run into a problem when I set conditional formatting in two of my fields, I recieve an error code in 2 of my other fileds. The error looks like this, #NAME. I'm still really new at this. If anyone can help I would really appreciate it.
THANKS
JIM

 

[Mile-O]

It sounds like you have a control bound to a non-existant field in the underlying recordset.

What's the expressions? Are they in the ControlSource?

What's the conditions of the formatting?

 

[jamesgonzo]

Thank you for your reply. The expression is in the control source. I'm using the expression to avg. my students grades. The expression is =[field]/4+[field2]/4+[field3]/4+[field4]/4. It takes 4 grades that are on my form and avg. them for me. The conditions of the formatting are less than 75, becomes red, bold font. But what's weird is that when the error occurs,I applied the conditional formatting to a field that is not in the expression itself.
THANKS
JIM