Datasheet column header

109bow

Registered User.
Local time
Today, 12:27
Joined
Oct 24, 2007
Messages
141
I have a sub-form which opens in datasheet view. Is it possible to increase the height of the column headers and wrap the text, so that I can reduce the column width and still not lose any text.
Also each column header has an arrow to allow sorting. Is it possible to turn this off within the sub-form.
Thanks in advance.
 
make a form, set it to datasheet mode.
you can set the headers and widths.
 
Ranman256, I have the form in datasheet mode and can set the column widths with the mouse. Setting the row height using the properties box only changes the row height for the records not the column headers, which is what I am looking to change.
 
datasheet view has its advantages and disadvantages. One of the disadvantages is you cannot change column header height except by changing font size, which would be no benefit in this case. And you cannot wrap the text in a headert

The arrow can be turned off by setting the form shortcut menu property (on Other tab) to No.

Usual solution is to use a continuous form
 
Thanks for the advice. I'm not familiar with a continuous form, what might that be?
 
Last edited:
If I cannot change the column header height, can I hide it, I can then add labels to the form to give the appearance of column headers?
 
depending on your version of access, it is also called a multiple item form on the ribbon and a tabular form in the form wizard

Or in form properties, click on the format tab, ensure Allow Form View is set to yes and then select Continuous Forms in default view.

If not used one before, highlight a table or query, then using the wizard select tabular form, or on the ribbon more forms, then multiple items form.

Don't ask me why so many names for the same thing, I don't know!
 

Users who are viewing this thread

Back
Top Bottom