Date data type NULL

[theDBguy]

Thank you everyone for the responses. I went with using the 12:00:00 AM as the base line the "Zero" if you will so in my if statement i just put that value in for if blank. The "And" and "&" debate ended up only working with AND in between, Access wouldn't let me use & it gave me an operator error.

Hi. Glad to hear you got it sorted out. Good luck with your project.

 

[Pat Hartman]

I know you decided on a "solution" but I disagree.

It would make more sense to make the date field a variant so you could check for null. That at least would correspond with how you would work with a control or a date field in a query which don't have defaults.

Since the variant is a non-specific data type, it won't restrict the input so to check for a valid date, you would use the IsDate() function. And keep in mind, just because Access thinks something is a valid date doesn't mean the data is rational in your context. For example #01/01/202# is a valid date as far as Access is concerned but it is a typo and not rational in context.