adjusting height of table header row or is there a fit to page opt

[Guest]

I don't know if it's technically called the header, but I'm referring to the
unchanging initial row of the table. I have a subform in a main form that
gets displayed in a datasheet view which then gets transferred into a report.
In order to fit the sheet, I need to raise the height of this inital "header"
row so that 3 word column-titles can go vertically where I have space instead
of horizontally where I do not.

Also, if there is a fit to page option similar to Excel that would solve the
problem too. I do not know of one though.

 

[Guest]

It sounds like you are talking about the labels that are found in the page
headers of a report. Labels can be resized. If you drag the top or bottom,
you can make the label taller. Then you can drag the left or right side to
make the label skinnier. This will force the text to be displayed in a more
vertical fashion. You can also make the text centered.

Instead of looking like this

It will
look
like this

 

[Guest]

It is not the label, but the title of each column for the table. The area I
am referring to is the greyed out area where the title of the column is. I
can resize the row height for the data-entry area, but I cannot adjust the
row where the title of the values are stored.

 

[Duane Hookom]

You can't change the column heading label heights. You can create continuous
forms with multiple line labels but this might not meet all your
specifications.