468,766 Members | 1,271 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,766 developers. It's quick & easy.

Multiline Column Heading In Datasheet View

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

Nov 3 '08 #1
4 10112
1,923 Expert 1GB
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
Nov 3 '08 #2
3,532 Expert 2GB
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)>
Nov 3 '08 #3
1,923 Expert 1GB
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.

Nov 3 '08 #4
3,532 Expert 2GB
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)>
Nov 3 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by John young | last post: by
2 posts views Thread by Claus Haslauer | last post: by
5 posts views Thread by rfdjr1 | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.