how do i put text values in date/time field in microsoft access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble setting a date/time data type field to accept text values.

For example,
Currently the date/time can only put dates (5-29-2005)

But, I want to put text in there too

For example: if the date is not available I would like put "N/A" to indicate
that date is not available.

Please help, I've spent days trying to figure this out for work. Thanks a
whole LOT!
 
A date/time field can only accept dates and times. It stores this data a a
number that represents the date and time. It does not store the actual date
and time you enter. No other type of data can be stored there. If you
want to make the field not applicable, leave it balnk.

On your forms, reports, and queries you can use the Nz function to display
"N/A" for any blank date fields.

Nz([SomeDateFieldName],"n/a")
 
Back
Top