• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 849
  • Last Modified:

"Not Applicable" in a date field in Access

I just had a request from a user in a database I developed.  The database keeps track of dates for  certain types of training.  When they run the report it shows blanks where there is no date entered.  If that training was not applicable to they would llike to be able to note that instead of having a blank field on the report. For example
name   training 1  training2  training 2
smith  01/01/01     na            05/05/10
Any ideas?
thanks
0
BOULMAN
Asked:
BOULMAN
1 Solution
 
MuralidharandCommented:
have you tried anything with CONDITIONAL FORMATTING in MS Access.....
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
One way I have handled this is to use the date 1/1/1/1900 to mean N/A

So the control source for the text box would be something like:

=IIF([MyDate1] = #1/1/1900#, "N/A",[MyDate1])

or maybe

=IIF([MyDate1] = #1/1/1900#, "N/A",Format([MyDate1],"MM/DD/YYYY"))





0
 
BOULMANAuthor Commented:
I think what I will do is convert the field to a text.  Then if they enter 01/01/1900 can have it converted to NA and still have the input mask setup with a date format.  
Thanks for heading me in the right direction!!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now