If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Date in Access field is ########
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? |
Thread Tools | |
Display Modes | |
|
|