Column headings

[ryetee]

I have a couple of questions relating to column headings and their widths!

1. What governs the width of a column and how can I change it. Changing the width in design mode doesn't seem to achieve anything.
2. Each of my columns has a heading which I can chose but can I wrap the text for the column headings at all. I have 1 column which will only ever be the width of 3 digits but the heading quantity in stock is taking up a load of room - and no I don't want to shorten this to anything!!

 

[EternalMyrtle]

Which column headings are you referring to? An image would be helpful.

 

[ryetee]

Which column headings are you referring to? An image would be helpful.

Right hopefully I have the file attached and you can see that the 3rd column in from the left has a heading Quantity. This should read Quantity in Stock. I do not want to alter the column width to cater for this neither do I want to truncate the heading. I want it to wrap over the equivalent of 2 lines. can this be done?

Changing the actual width of each column is also a pain. The design width seems to have no bearing on the form width. I've changed it in many places only for it to revert to the original width. I've now set the columnwidth control in the form load but I'm dubious that this works properly.

Anyway wrapping the text in the heading is my main agenda now!!

 

[JHB]

...
Changing the actual width of each column is also a pain. The design width seems to have no bearing on the form width. I've changed it in many places only for it to revert to the original width. I've now set the columnwidth control in the form load but I'm dubious that this works properly.
...

Changing the column width in form view, will keep the width it is set to manually, also after closing and opening the database again - at least by me!
It don't think you can wrap the text in the heading in datasheet view.

 

[EternalMyrtle]

I have found that you have to change it in the normal form view, which has its flaws. If you change it there and then save and close it will open up to the last setting. This is why I usually use continuous forms instead of datasheet.

You cannot wrap text in a datasheet unless you make the row height bigger and that means that all your rows will be higher.