How do I put column headings on 2 rows in Access like Excel

E

Edna

In a computer class, we would like to put a column heading, such as
Technician Number on 2 rows like you can in Excel to save paper. Is there a
way to do this?
Thanks for your help.
 
J

John W. Vinson

In a computer class, we would like to put a column heading, such as
Technician Number on 2 rows like you can in Excel to save paper. Is there a
way to do this?
Thanks for your help.
Click to expand...

Excel is not Access. THEY ARE DIFFERENT.
A Table is not a spreadsheet. THEY ARE DIFFERENT!

Tables are for data storage, not for printing or presentation. Create a Report
for printing; there, you can control the labels and headers to your exact
preference.
 
F

fredg

In a computer class, we would like to put a column heading, such as
Technician Number on 2 rows like you can in Excel to save paper. Is there a
way to do this?
Thanks for your help.
Click to expand...

What did your instructor say?
 
K

Ken Sheridan

For printing always use a report. Don't print a datasheet or a form. In a
report you can control the layout in many different ways, grouping the report
and including values in a group header and/or footer for instance, or you can
use subreports to include data from a related table or tables.

Take a look at the reports in the sample Northwind database which comes with
Access to see some examples of what can be done. And read up on reports in
the Help system.

Ken Sheridan
Stafford, England
 
D

Dick D

Edna,

Yes, you can place this on two rows by using labels in a form or a report.
This is implied in the other responses. Printing Tables and/or Queries is
more of a debug or audit option and not intended for normal production
reports.

If you don't want to create a form or report, you still have the option to
copy the table to Excel or to export to Excel - the field headings become the
column headings and you may wrap the column headings. These spreadsheet
results "can be printed to save paper"
 
Top