(Access) how to automatically format exported information?

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

Guest

I am exporting information from Access into an Excell file. Is there a way
that I can get the Excell file to be formated so the column names will be
text wrapped, the column width will automatically be 10 in width or only
allowing enough space to show the necessary information?

Also how can I have it so that there is a drop down when I enter the first
letter into a feild instead of having to scroll down through the entire list
of items in Access?
 
you have to use automation

Pieter

BLandis said:
I am exporting information from Access into an Excell file. Is there a way
that I can get the Excell file to be formated so the column names will be
text wrapped, the column width will automatically be 10 in width or only
allowing enough space to show the necessary information?

Also how can I have it so that there is a drop down when I enter the first
letter into a feild instead of having to scroll down through the entire
list
of items in Access?
Click to expand...



--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export reports to html format automatically 0
Exporting a table from Access 2003 to Excel 2007 1
Export from specs not working properly 1
Exporting Access Table to text file 9
Exporting Fixed Width Text File 4
Export records to multiple Word files 2
How do I automatically export from Access to Word? 2
excel formatting through access 4

Back
Top