Move a field when exporting into Excel

[Guest]

Hello,

I have a question about the way my report is exporting. Everything works
fine and all the data exports. However, for some reason the Address field is
exporting after the State field and the manager wants it to be before the
City. In my report it lined up correctly and also in the query, form and
table the address comes before the City but when exporting it's coming out
after State.

Is there any way to fix this within Access so it exports correctly?
Otherwise, I'll have them correct it in Excel.

Thanks!!!!

 

[Carl Rapson]

Hello,

I have a question about the way my report is exporting. Everything works
fine and all the data exports. However, for some reason the Address field
is
exporting after the State field and the manager wants it to be before the
City. In my report it lined up correctly and also in the query, form and
table the address comes before the City but when exporting it's coming out
after State.

Is there any way to fix this within Access so it exports correctly?
Otherwise, I'll have them correct it in Excel.

Thanks!!!!

Could the report be exporting the fields in tab order? Check the tab orders
of the fields on the report and see if they match the order in the export.
If so, change the tab order to be the way you want it in the export.

Carl Rapson

 

[Guest]

Hi Carl,

I didn't see a Tab Control on the fields for the report. However, I did tab
from one field to the next and it does tab in order Adress, City, State and
Zip. I just don't know why that address field comes out that way. Any other
suggesting?

 

[krissco]

Check to see if the placement of your controls needs fine tuning.
Design the report and click on Properties of each of the controls you
are interested in. I suspect that Address has a slightly lower "Top"
than the other controls.

-Kris

 

[Guest]

Hi Kris,

That was it!

Amazing, I would have never thought about that? Excellent piece of reference
going forward. I've looked all though the database and couldn't find anything
wrong and was baffled as to why this is happening.

Thank you very much for your help, your knowledge is greatly appreciated!!!!

Have a great weekend!!