Sending report to email as a xcel file and incorrect information shows.

[puforee]

In my DB I run code that loads a table. I have a Report that sends the data from the table. In VBA I am using DoCmd.SendObject to send the report as Excel to my users. It does not arrive the same. On Label is incorrect.

Troubleshooting by exporting the report from Print Preview to excel:

The issue: When I preview the report manually it shows 9 fields. The problem field is Labeled "End Date" in the preview and on the report in design view. The data portion of the field is formatted as a date and exports good. In print preview everything looks good. When I export to excel (or email as excel) the field label shows "Completion Status" instead of "End Date". The actual data part of the field shows the date correctly.

In the referenced table for the report there is NOT any field labeled "Completion Status". And the report in design view, does not have a label named Completion Status".

Do you have any ideas why this is happening? The data is good but the one label is not. There are 9 fields and all nine data-es look good and all labels except the one are good.
Also, with a report in Design View is there any way search for the offending label?

Thanks,

John

 

[puforee]

OK. I fixed this. I don't know why it was doing it but I created a new report using the same data from the same table. I ran the code to send it to me via email and everything looked good.
John

 

[lameid]

Sounds like corruption... Compact/Repair sometimes helps..
Sometimes importing all objects to a new file helps...
Sometimes exporting with the undocumented SaveAsText and loading with loadfromtext can fix an object... generally also import everything else to a file and load it there.