Column Heading Text Wrap?

[frosty2000]

I have created a form to enter employee data, and a subform to enter dependent data. My subform is currently set in Datasheet view (so that it looks like a table).

My question is - Is there a way to wrap the text in the column headings on my subform? For example, one column heading on my subform is "Dependent Gender". If possible, I would like to make the width of the column as small as possible (since the only possible entries are "Male" or "Female". Similar to how Excel works, I was hoping to increase the height of my column headings and wrap the text so that "Dependent" is on one line and "Gender" is on the other when I shrink the column size. Is there a way to do this in Access?

Thanks,
frosty2000

 

[PHV]

You may consider continuous subform instead of datasheet view.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[traingamer]

Or you could simply change the column heading to 'sex' or 'gender' since your subform only has 'dependent' data anyway and the word would be redundant.

traingamer

 

[TheAceMan1]

How are ya frosty2000 . . . . .

[blue]PHV[/blue] is on target. With Continuous forms you can [blue]insert new lines in labels[/blue] (Ctrl + Enter) and [blue]center the lines[/blue] . . .

See Ya! . . . . . .