Conditional formattting of dates

[integritycare]

Hi all,

I have a date field that when it is null that I can use conditional formatting to show that the field is empty..
This is what I have used

condtion
Field value;   less than = Date()

However it wont work...
Many thanks

Integrity

 

[SkipVought]

<=Date()

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[missinglinq]

Skip has shown you the correct syntax for the code you were attempting, but what does showing that a "Field is Null" (your question) have to do with the Field being less than the Current Date, which is what you attempted with your example?

To use Conditional Formatting to indicate that the Field is Null, in Form Design View, you'd
[ul]
[li]Right-Click on the Control[/li]
[li]Click on Conditional Formatting[/li]
[li]Under Condition1 select Expression Is[/li]
[li]In the Condition Box enter IsNull([FieldName])[/li]
[li]Select the desired Formatting[/li]
[li]Click on OK[/li]
[/ul]
Replacing FieldName with the actual name of yours. And note that it is mandatory that you have the Square Brackets around the name, as shown above.

The Missinglinq

Richmond, Virginia

The Devil's in the Details!