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