By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Multiline Column Heading In Datasheet View

P: 30
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
Nov 3 '08 #1
Share this Question
Share on Google+
4 Replies


puppydogbuddy
Expert 100+
P: 1,923
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

missinglinq
Expert 2.5K+
P: 3,532
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

puppydogbuddy
Expert 100+
P: 1,923
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
Nov 3 '08 #4

missinglinq
Expert 2.5K+
P: 3,532
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.