Hi,

I would suggest that you not do that. It will cause more problems than
it will solve. If you set the field to allow for Null (i.e. not be required)
then when it is not available or not needed, just leave it blank. If you
need to specify the difference between N/A and not needed create another
field to records that piece of information. Such as Reason_for_No_Date which
might be a Text field of say two characters; maybe with the following values:
NA for N/A or NN for not needed.

Clifford Bass

"StarrKittrell" wrote:

I want to format a field in a table to take either dates or text. Now if I
format it for "short date" it won't let me type in text ie: N/A or not
needed. Can this be done?