I have an unbound form where one of the date fields is optional. However, in the code, it inputs #12:00:00 AM# as the value. I can't set it to Null nor "" as this is for text. So, if a date field on a form is optional, how can I text for this in the vba. If it does not have a value, I want to run one DoCmd, and if it does have a date, run a different DoCmd.