I have a shortdate text box (MyDate) that I want to filter by testing
for a null value, but:
Me.Filter = "MyDate = Is Null"
Me.FitlerOn = True
does not work. I also tried a null string ("MyDate = ''") and paired
delimiters ("MyDate = ##") but can't get it to work. I assume it has
something to do with the date format. Any hints?
thanks