A form with a text box expecting a date has the validation property as, >#1/1/2010# And Is Not Null. If a date is entered older that this the error is caught however if the field is left null it is not caught as an error. I have tried several modifications of this statement with the same results. Is it the syntax or am I missing something?
Test for null date
- Thread starter hduvall
- Start date
pr2-eugin
Super Moderator
- Local time
- Today, 16:44
- Joined
- Nov 30, 2011
- Messages
- 8,494
Please do not post Questions in "Introductions", I have moved it to the right category.
Hello hduvall, Welcome to AWF
Where are you trying this? Query ? Code? If the Date field contains a Date it is not going to be Null. So Testing If it has a Date and Is not Null is logical absurdity. If you could explain where you are trying to perform this action, we could be able to give you a better solution.
Hello hduvall, Welcome to AWF
Where are you trying this? Query ? Code? If the Date field contains a Date it is not going to be Null. So Testing If it has a Date and Is not Null is logical absurdity. If you could explain where you are trying to perform this action, we could be able to give you a better solution.
I am in a form updating table records with different dates per record. I started with a validation rule on the text box >#01/01/2010# thinking that null was not greater than this date, and was successful if the entered date was less than this date. However it let a null date in this field pass. I have tried a dozen combinations but nothing has caught the null field.
Similar threads
