Filter Date Text Box

[data808]

I've been setting up some query forms with text boxes. These forms are split forms with datasheet on bottom. I have some filter unbound text boxes with a filter button and undo filter button. The question I have is for my date text boxes. The date text boxes work to filter out the specific date that I'm looking for but I have to type it EXACTLY how the date is formatted in the datasheet. Example: 9/15/2010. I cannot type 9-15-2010 or 09/15/2010 because its not EXACTLY the same as the date in the datasheet so it will give me no records.

Is there a way to make it so the text box can convert the date into the correct format so it is able to filter what I need?



Any help is appreciated.

[pbaldy]

What is the data type of the date field in the table? Sounds like it may be text rather than date/time. You might also want to give the textbox a date format.