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

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.

On Mon, 27 Oct 2008 10:01:01 -0700, Edna
wrote:

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.

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.
--

John W. Vinson [MVP]

On Mon, 27 Oct 2008 10:01:01 -0700, Edna wrote:

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.

What did your instructor say?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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

"Edna" wrote:

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.

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"

--
Hopefully helpful,
Dick D

"Edna" wrote:

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.