Solved

Date Field Conditional Formatting - revisited

Posted on 2012-03-13
3
249 Views
Last Modified: 2012-03-13
Follow up to:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27627895.html

DateDetermination: IIf(IsNull([MedicalCertExpireDate]),"None",[MedicalCertExpireDate])

Works fine (showing all records with dates and displaying 'None' if no date).
I actually need to show Records with date <Now() and those with no date as 'None'.  I added this to criteria which filtered ok but then I lost those records in which had no date 'None'.

Thanks
0
Comment
Question by:zpotok
3 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 37715001
Try this for your date field's criteria:

< Now() OR IS NULL
0
 
LVL 39

Expert Comment

by:als315
ID: 37715134
DateDetermination: IIf(IsNull([MedicalCertExpireDate]) Or [MedicalCertExpireDate]<Now(),"None",[MedicalCertExpireDate])
0
 

Author Closing Comment

by:zpotok
ID: 37715242
Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Library not Registered 16 45
COPY from excel to notepad 3 35
how to address a subform in a form, from inside another subform 2 22
Access coding 2 0
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now