How can you change an Access datasheet column header height or wra

[Guest]

If you have a column in an Access datasheet where the name is larger than the
data, it would be nice to be able to make the column header wrap or be able
to resize the datasheet header row to display more than one line.

 

[Larry Linson]

If you have a column in an Access datasheet where the name is larger than
the
data, it would be nice to be able to make the column header wrap or be
able
to resize the datasheet header row to display more than one line.

You don't have nearly the formatting capabilities in datasheet view, because
the capabilities are provided in Forms and Reports. Try creating a Form in
ContinuousFormsView to display your data and you can size the Labels
(headings) as you wish.

 

[Guest]

Thanks Larry,

I was aware of the continuous form option. I am prototyping an application
and liked the default formatting of the datasheet since I have about twenty
of them. Additionally, the DS provides the column functionality (in the
column header) by default giving my users an easy way to change their sort
preferences, filters, column order, etc.

 

[Larry Linson]

I was aware of the continuous form option. I am prototyping
an application and liked the default formatting of the datasheet
since I have about twenty of them. Additionally, the DS provides
the column functionality (in the column header) by default giving
my users an easy way to change their sort preferences, filters,
column order, etc.

Many experienced Access developers avoid giving users the capability for
datasheet view because (we have learned from unpleasant experience) it is so
easy for them to inadvertently make changes or updates that aren't
beneficial. Datasheet view is useful for end-user databases, but I provide
the necessary functionality in my applications.

Larry Linson
Microsoft Access MVP

 

[Guest]

Many experienced developers find that involving the users in the UI design
process with a prototype results in a deliverable with a longer life cycle,
reduced change orders and a very high user satisfaction rating.

Thanks for your help.