Date in Access field is ########

  • Thread starter Thread starter CSR@AEWJL
  • Start date Start date
C

CSR@AEWJL

I recently ran a query based on the date field. Ever since then, some of the
dates in the field show up as ###### instead of the date I originally
entered. How do I fix this?
 
If you have lived a good, wholesome life, it's probably just that the field
holding the data isn't wide enough. Try widening up the column or text box.

That isn't it? What DID you do? ;-)

I would be worried that your database may be corrupt. Make a copy of the
entire database file first. Then do a compact and repair on the database and
see if that fixes it.
 
Back
Top