Datasheet view

[Jasper Recto]

Is it possible to make the label in the datasheet view wrap itself?

I have a label that's very long and I would like it to wrap the words so
that it's 2 lines instead of one. That way I can shrink the column down and
still see the entire label.

Is this possible?

Thanks,
Jasper

 

[Jerry Whittle]

In a word: No.

But you can open the table in Design View and change the Caption property to
something shorter. Having said that, I would not recommend doing this.
Messing with the caption property can cause a lot of confusion when you are
trying to troubleshoot problems.

 

[Tom van Stiphout]

On Mon, 21 Jul 2008 10:57:42 -0400, "Jasper Recto"

If you have a narrow column in a data sheet, and you increase the line
height by in the record selector (the gray box at the beginning of a
row) dragging the bottom line down, you get taller rows and can see
more of the text.

-Tom.
Microsoft Access MVP

 

[Arvin Meyer [MVP]]

Is it possible to make the label in the datasheet view wrap itself?

Not in datasheet view, but you can in continuous form view and easily make
the continuous form look like a datasheet if you want to.

 

[Jasper Recto]

What is continuous form view? How do I get to it?

Thanks,
Jasper

 

[John W. Vinson/MVP]

What is continuous form view? How do I get to it?

OPen the Form in design view. Find the "Default View" property on the
form's Properties (right click the little square at the upper left
intersection of the rulers and select Properties); you have the choice
of "Single", "Continuous" and "Datasheet".

 

[David W. Fenton]

Not in datasheet view...

I thought Michael Kaplan alluded to a number of things you can do
with datasheet views of Access tables. I think he said you can
change the properties of the datasheet from code, but, of course,
you can't store the code in the datasheet itself. Yes, a datasheet
form is a lot easier to deal with, but I'm pretty sure you can do
things with it (I recall trying out his suggestion, but don't
remember any of the details of how it worked -- can't find anything
in Google, unfortunately). Ah, yes, just looking through the object
browers, I see you can access a lot of properties via:

Screen.ActiveDatasheet

Note that if you want access to the value of a field, you can call
it by name, though you have to use the ! and not the . (since this
is not a form, the implicit property wrappers do not exist).

I see no way to adjust the appearance of a column, but you can
change the properties of rows.

You can do quite a lot with this, though I'm not entirely certain
why one would bother when it's so much easier with a datasheet form!

 

[Arvin Meyer [MVP]]

I thought Michael Kaplan alluded to a number of things you can do
with datasheet views of Access tables. I think he said you can
change the properties of the datasheet from code,

There are quite a few properties that can be changed in a datasheet form
(including some column properties, like column width) but the label cannot
have 2 lines. You can bold all the labels (along with the data) and change
the text color (also with the data) and you can also get some of the
conditional formatting properties to work. But no line wrapping.