If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Move a field when exporting into Excel
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!!!! |
#2
|
|||
|
|||
Move a field when exporting into Excel
"Stockwell43" wrote in message
... 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 |
#3
|
|||
|
|||
Move a field when exporting into Excel
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? "Carl Rapson" wrote: "Stockwell43" wrote in message ... 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 |
#4
|
|||
|
|||
Move a field when exporting into Excel
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 |
#5
|
|||
|
|||
Move a field when exporting into Excel
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!! "krissco" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|