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

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"CSR@AEWJL" wrote:

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?