How can I format column settings in Access designview to "Wrap"

C

Column Title Wrap

In database designview I would like to format the column headings to wrap.
This will allow more efficient use particularly when designing/printing
reports where the title is longer than the record entry.
 
R

Rick B

You would do this in your reports (since you mention printing) not in the
table design. Once you get your database built, you should rarely open the
table again. All your data entry and editing should be done in your forms.
Printing of the data should be done in the reports.

Your tables do not offer fancy formatting options.
 
J

John Vinson

On Mon, 19 Sep 2005 08:13:05 -0700, "Column Title Wrap" <Column Title
In database designview I would like to format the column headings to wrap.
This will allow more efficient use particularly when designing/printing
reports where the title is longer than the record entry.

I would be inclined to separate the issues of data STORAGE - in your
tables - from data DISPLAY.

Field names should generally be kept short (so your queries are
readable), free of blanks and special characters, and use a consistant
naming convention. They'll typically not be all that suitable for
printing on reports. For your printing, I'd suggest setting the
field's Caption property or (more likely) setting up your fields'
labels in report design.

John W. Vinson[MVP]
 
M

Montag451

Column Title Wrap said:
In database designview I would like to format the column headings to wrap.
This will allow more efficient use particularly when designing/printing
reports where the title is longer than the record entry.
 
M

Montag451

In Design View of my Reports I increase the height of the Page Header, move
the line down then paste the relevant label beneath the original, positioning
this and deleting text as necessary ('House Number' and 'House Number' become
'House' and 'Number')
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top