Out of Range Error

[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?

 

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

 

[Brenda from Michigan]

Thanks for the suggestion. I'll have the user give it a try.