Out of Range Error

  • Thread starter Brenda from Michigan
  • 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?
 
J

Jerry Whittle

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.
 
Top