That's the strange thing - there are no blanks in the dataset, I tried.
As another approach, I used the DateValue() function and that allowed me to convert the text to date - however I think because Access thinks that the field is text, it won't allow me to use date functions to specify query...