By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,139 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,139 IT Pros & Developers. It's quick & easy.

WrapText in Docmd

P: 37
Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "table1", path
How to use the WrapText property to allign the cells according to the content of the table?
Feb 28 '09 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,419
What WrapText property?

What actually do you want to achieve?
Feb 28 '09 #2

Expert 5K+
P: 8,623
The only way that I see this happening is:
  1. Export the Table to an Excel Spreadsheet as previously indicated.
  2. Open the Spreadsheet via Automation Code, then apply this Property to specific Cells as needed.
  3. The Syntax (within Excel) would be:
    Expand|Select|Wrap|Line Numbers
    1. Worksheets("Sheet1").Range("B1").WrapText = True
  4. I imagine that the problem would be to determine when and where to apply this logic.
  5. Good Luck.
Feb 28 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.