Conditional formatting

[keiath]

Now try the IsNull parts without the date condition.

(IsNull([Accounts Sent to Residents])) works and field goes red

[June7]

Try both IsNull conditions together.

Then try with all three conditions. If it still fails, got no clue what's wrong.

[keiath]

(IsNull([Accounts Sent to Residents]) And IsNull([Section 20B Sent]))

Works field goes red but of course now all fields are red regardless of whether deadline date has passed becuase of no sysdate

[June7]

And now you need to try all three again.

[keiath]

As soon as i put in sys date

(Date()>IsNull([Accounts Sent to Residents]) And IsNull([Section 20B Sent]))

all fields are red and when i enter Resident date its still red! So yeah at a lost here

Interestingly though when i put this,

(IsNull([Accounts Sent to Residents]) And IsNull([Section 20B Sent])<Date())

All records Deadline Date are Red BUT this time when i enter the Residents Date it goes back to White

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

[keiath]

Hi

Here is a zip up folder of database

I left 3 records in there so you can see what should be happening with the fields

[June7]

Which form?

[keiath]

2014 Accounts Tracker Main Data

[June7]

Okay, now which textbox(es) on that form, there are a lot.

[keiath]

Account Deadline and Sec 20B Deadline

Section 20B Sent and Sent to Residents are the fields the above to to "look at"

[June7]

You show expression using

Date()>[Account deadline date])

There is no field or textbox named [Account deadline date]

There is a textbox named [Account Deadline]

Fix the reference and condition works.

Date()>[Account Deadline] And IsNull([Accounts Sent to Residents]) And IsNull([Section 20B Sent])

[keiath]

THANK YOU so much just wouldnt have seen that, fresh eyes makes all the diffrence

[rpeare]

how about supplying an example database to play around with? Isnull should work with date fields if there's nothing in them and I can't understand why it wouldn't work for you.

This is the expression I used and it correctly highlighted the appropriate line:

(Date()>[account_deadline_date]) And (IsNull([Accounts_sent_to_residents]) And IsNull([section_20b_sent]))

Use the EXPRESSION IS when you create your rule.

One other note, I don't use spaces in anything I create, leads to more programming issues than anything else so I replaced all your spaces with underscores (_) in my test.