Multiline Column Heading In Datasheet View

[scottbouley]

I have two columns containing checkboxes in datasheet view on a subform. The check boxes don't require much space but they have to be huge to fit the column heading without abbreviating beyond recognition. I'd like to make the column heading mutliline but can't figure out how to do it; no matter what I do only the first line appears.

I've tried changing the label size
Using VbCrLf in the caption
There is no Can Grow property

Any Ideas

Thanks

[puppydogbuddy]

If you are at the end of a line in a label and want to go to a second line:
hit these keys:.................> CNTRL + Enter

[missinglinq]

Sorry, but I think you'll find that while this will appear to work in Design View, when you actually run the form, in Datasheet View, you'll only see the first line. In Datasheet View your formatting is really limited to whatever can be done in Conditional Formatting from the menu. Unfortunately, this doesn't include enlarging the label sizes. The usual workaround for this kind of thing is to switch the subform from Datasheet view to Continuous view and then format it to look like Datasheet view.

Linq ;0)>

[puppydogbuddy]

Hi Linq,
Just for the record the CNTRL + Enter works for me in Form View. I have never tried it in Datasheet view, so I presume you are correct about it not working in Datasheet view.

pDog

[missinglinq]

That's correct, it does work in Single View (Form View) as well as in Continuous View, but not in Datasheet View. As I said, you're pretty much limited in Datasheet View to the little bit of formatting you can do using the Conditional Formatting. The sneaky thing is, Access will let you do all kinds of things in Design View; add command buttons, add labels and headers and change font colors and so forth, but when you run the form in Datasheet view, all of these changes vanish!

Linq ;0)>