Out of Range Error

  • Thread starter Thread starter Brenda from Michigan
  • Start date Start date
B

Brenda from Michigan

Access 2002 SP3

User has exported a table to Excel but she gets an Out of Range error giving
the row number. The field is a date and it is setup as a Short Date in
Design View. The data is 3/25/2008. It is the same as all the other dates
in that field and the user wants to know why it errors on this specific date.
Any ideas?
 
Even though it's formatted as Short Date, it could have a time element stored.

Try exporting a query based on the table. Use the Format function to display
it as a Short Date. That will export it as text instead of a date or number.
 
Back
Top