How can I make this

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
You're not going to get nearly the same quality of layout as Excel, but in your Report Wizard, you can choose from several different options on how your report will layout. One of these puts a rectangle around every field so that when you print out, it looks something like a spreadsheet. My best advice, though, would be to use Access for your data storage and Excel for your output: In your Access report, click Tools, Office links, Analyze it with MS Excel. Or, if you run this report frequently and want to consistently have the layout power of Excel, design a worksheet in Excel that looks exactly how you want it, then use Data, Get External Data, New Database Query, and then navigate to your database and then to the query within your database. You can set the option to have this Refresh on Open, which is quite nice.
 
Upvote 0

Forum statistics

Threads
1,221,510
Messages
6,160,230
Members
451,632
Latest member
purpleflower26

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top