How to wrap column headers in subforms

[08211987]

Is there a way to wrap column headers in subforms. I was thinking I could edit the caption property possibly with a vbCrLf at the end of first line? But I am not even sure where I would place that code.

Any help would be appreciated - thanks!

 

[dhookom]

Column headers are typically label controls. You can insert carriage returns by holding the control while pressing enter.

I don't believe there is any way to wrap column headings of a datasheet view.

Duane
Hook'D on Access
MS Access MVP

 

[08211987]

Ok thanks, yes it is a datasheet view.

 

[sxschech]

May not be ideal, but if your subform is fixed and the col widths or position don't move, you could create labels directly above the subform on the main form and then you can have them wrap as desired.

 

[08211987]

This might work if I knew how to force a subform's columns to be fixed.
Thanks!

 

[dhookom]

Why not use a continuous form rather than datasheet view?

Duane
Hook'D on Access
MS Access MVP

 

[08211987]

Thanks Duane,
Yea I've thought of that due to some posts I've seen, I've just not read up much on those to see how much work it would be to change it to that. Maybe I should start reading, thanks.