Hi,
I have a weird issue concerning exporting Access 2000 reports to Excel 2000. When a report is run within the application, all fields are displayed on the screen properly formatted, etc. However, when the report is either exported to an Excel spreadsheet using the OfficeLink option of "Analyze it with MS Excel" or using the File menu option "Export" to export as an Excel 97-2000 spreadsheet, one of the text fields containing a control number in the format ##-###-## (eg. 01-000-02), gets converted into a negative number. The negative number is not even one that makes sense. I am not sure why this is happening.
I have made a work around in which a control button runs some code to execute the queries used in the report and then exports the results to an Excel spreadsheet for import into a template. This works without a problem!
What the heck is going on here?!
Any help would be greatly appreciated.
Thanks,
Scott.
I have a weird issue concerning exporting Access 2000 reports to Excel 2000. When a report is run within the application, all fields are displayed on the screen properly formatted, etc. However, when the report is either exported to an Excel spreadsheet using the OfficeLink option of "Analyze it with MS Excel" or using the File menu option "Export" to export as an Excel 97-2000 spreadsheet, one of the text fields containing a control number in the format ##-###-## (eg. 01-000-02), gets converted into a negative number. The negative number is not even one that makes sense. I am not sure why this is happening.
I have made a work around in which a control button runs some code to execute the queries used in the report and then exports the results to an Excel spreadsheet for import into a template. This works without a problem!
What the heck is going on here?!
Any help would be greatly appreciated.
Thanks,
Scott.
