How do I validate user input when asking for a date, but allowing null values

[Sardinka]

So the goal of my code is to allow a user the option of querying their results using a start and end date (neither are required, but both have to be present for the query to run)

My code for the criteria looks like this:

Between IIf(IsDate([Forms]![Query Transaction Form]![StartDate]),[Forms]![Query Transaction Form]![StartDate],"*") And IIf(IsDate([Forms]![Query Transaction Form]![EndDate]),[Forms]![Query Transaction Form]![EndDate],"*")

Access keeps telling me its incorrect or too long, what can I do?

[Seth Schrock]

Based on your form name, I'm going to guess that you have a form with a button to run a query based on the values in the textboxes for your date range. If this is the case, then you are better off doing your validation as a test before running your query. I have never tried it, but I don't think that your query will work using the Between * And * which is what would happen if your data wasn't valid. You may need to change the SQL of your query depending on if there is a date provided or not.

[Sardinka]

How would I validate beforehand if I am allowing users to not enter a date and run the query based on all date ranges?

[jforbes]

You might want to look at this as it is similar http://bytes.com/topic/access/answer...es#post3792346

[Sardinka]

Thank you for all the help! It worked.

[NeoPa]

A similar approach might be :

Between Nz([Forms]![Query Transaction Form]![StartDate],#1/1/1900#) And Nz([Forms]![Query Transaction Form]![EndDate],#12/31/9999#)