Combo box help

[MooG]

Is it possible to have a combo box that shows date and text? I would like to have a combo box with dates that also allows the user to choose the word "unassigned." the reason for this is because sometimes we don't know dates due until a future time and that is specifically what my boss wants. They don't want the field empty either.

 

[Pat Hartman]

If you are asking - can you store text in a date field? The answer is NO. Dates are numeric and are stored as double precision numbers. You can display "unassigned" for null values when you produce reports, just not in your data entry form. Don't even consider storing dates as text strings to satisfy this request. That will cause nothing but trouble every time you try to use the date. Access is NOT Excel. It is a relational database and all relational databases require consistancy of data type within each column.

 

[John Big Booty]

Rather than using a Combo to select dates, why not use a Date Picker such as the one presented here?

You could then use the Nz() function to display "Unassigned" when no date has been selected.