Entering Text in a Date (numeric) field possible?

[Titleist]

Greetings to all,

I'm sort of a newbie so please forgive my ignorance...

I have a form with 2 Date fields, a Start Date and a Completion Date. Each date field is setup with the Show Date Picker (little pop-up calendar) so users can simply click their desired dates.

My issue is that I need the user's to also be able to enter Text in either date field. I need them to be able to enter "Previously Qualified" OR pick a Date.

I've spent some time experimenting with the Text Box property sheet settings with no luck. Is this possible?


Thanks!


Titleist

[June7]

Then can't be a Date/Time datatype field. As a text datatype field, date would only be a string of characters. Access would not recognize as a data value.

Textbox cannot be formatted for date and still allow text and you won't get the date picker without the date format.

Bad design to mix data types in the same field.

[Titleist]

So the answer in NO. Thanks for the response.