Hold format when exporting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I do an export from Access Reports to Excel the columns do not format
and the field names do not format automatically. I would like the following..

1. Field names to hold the same color and size
2. All the columns to format automatically
3. Show the report name at the top of each page
4. Show the header at the top also (if possible)

Thanks in advance
 
Sorry, that is not going to happen. The only way to get a report in Excel to
format exactly like you want it is to use Automation to create an Excel
Object in Access and use VBA to format the worksheet and place the data where
you want it. There is a bit of a learning curve, but it has become the way I
do it, including creating charts an graphs. It takes a lot of code, but it
is the only way I know of.
 
Back
Top