unable to set field.name in VB

  • Thread starter Thread starter 7domino
  • Start date Start date
7

7domino

I created a form where data is filtered and exported to Excel.
My user complaints that the headers are not specific enough. He would like
them to reflect the months of the quarter that is reported on.
Changing the headers in the form headers.caption at form load time works fine.
Exporting data to Excel though uses the name of the field and not the headers.
When trying to change the field.name, I get the message to
"To set this property OPen the form in Design View"
Is there a way to change the name of the fields in the form or make the
Excel export use the headers. Thanks in advance for any enlightenment
 
7domino said:
I created a form where data is filtered and exported to Excel.
My user complaints that the headers are not specific enough. He would
like
them to reflect the months of the quarter that is reported on.
Changing the headers in the form headers.caption at form load time works
fine.
Exporting data to Excel though uses the name of the field and not the
headers.
When trying to change the field.name, I get the message to
"To set this property OPen the form in Design View"
Is there a way to change the name of the fields in the form or make the
Excel export use the headers. Thanks in advance for any enlightenment
Click to expand...


Create a query that selects the fields from the original table (or query),
but renames them the way you want. Export that query instead of your form,
or else make that query the recordsource of your form, too (and change the
controlsources of the controls that werre bound to the renamed fields).
 
Back
Top