Word Wrapping Column Headers

[Guest]

I am using Access 2003.
The headers are overpowering an already huge spreadsheet. How can I word
wrap them to a more suitable size? I understand using the "Enter Key
Behavior" function for the data but don't see that option in the header
properties. Thank you.

 

[John Spencer]

You can't do that in a query or in the datasheet view.

If you wish to Wrap the headers, you will have to create a form in
continuous view and then you can wrap the Column Labels as you see fit.

You can use the Form Wizard to build a form as a start and then modify it as
needed.

New Form
AutoForm: Tabular
Choose a table or query as the basis for the new form
Press OK and the form will be created. If you like the way it looks you can
save it and modify it.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Arvin Meyer [MVP]]

You cannot change the size of the caption headers in datasheets. You can in
a continuous form by using Ctl+Enter where you want to divide the caption
and making the header tall enough.

 

[Guest]

The form is already created although I'm not clear on the "continuous"
description.
Is that something different than the standard form using the wizard? Also,
I used
AutoForm: Datasheet but saw you mentioned AutoForm: Tabular, could that be
the problem?


--
Financial Analyst
Healthcare Industry

You can't do that in a query or in the datasheet view.

If you wish to Wrap the headers, you will have to create a form in
continuous view and then you can wrap the Column Labels as you see fit.

You can use the Form Wizard to build a form as a start and then modify it as
needed.

New Form
AutoForm: Tabular
Choose a table or query as the basis for the new form
Press OK and the form will be created. If you like the way it looks you can
save it and modify it.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[John Spencer]

Yes. As I said you cannot wrap the column labels in datasheet view. Try
recreating this using AutoForm: Tabular. You will still need to do some
editing in the form's design view to get things as you wish.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

The form is already created although I'm not clear on the "continuous"
description.
Is that something different than the standard form using the wizard?
Also,
I used
AutoForm: Datasheet but saw you mentioned AutoForm: Tabular, could that be
the problem?

 

[Guest]

I'll give it a shot. Thanks.