Formatting in Access?

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

Guest

My report has an extremely wide column because the column title is long. How
can I shorten the column by having the title in two lines (rows) instead of
in in long line? The data in the column is numbers and very short. I know I
can shorten the column by moving and dragging the column lines around it, but
that also shortens and cuts out my title and I needed the entire title.
Thanks.
 
My report has an extremely wide column because the column title is long. How
can I shorten the column by having the title in two lines (rows) instead of
in in long line? The data in the column is numbers and very short. I know I
can shorten the column by moving and dragging the column lines around it, but
that also shortens and cuts out my title and I needed the entire title.
Thanks.
Click to expand...

And the title is? In a Label?

You can insert a line space in the label.

"This is line 1" Ctrl + Enter "Line 2
 
My report has an extremely wide column because the column title is long. How
can I shorten the column by having the title in two lines (rows) instead of
in in long line? The data in the column is numbers and very short. I know I
can shorten the column by moving and dragging the column lines around it, but
that also shortens and cuts out my title and I needed the entire title.
Thanks.
Click to expand...

If it's a Report, you can change the header however you wish: it's just a
label. You can get into the label in report design mode, click after a word,
and press Ctrl-Enter to insert a new line to make the label two lines; you can
change the title to something more compact; you can delete the label
altogether. You're NOT stuck with what the wizard builds for you!

John W. Vinson [MVP]
 
Back
Top