Text wrap in column headings

[yoled333]

Can you tell me how to wrap text in column headings? I also need to know how
to wrap text in a cell. Thank you.

[Ken Snell]

You cannot wrap the text in a table's datasheet view's column (field)
headings. You must use a form with textboxes, where you put the name of the
field in the textbox, to do that.

To "wrap" a textbox, you must insert the combination of carriage return and
line feed characters into your data where you want the text to "wrap" --
i.e., make a new line. ACCESS does not automatically wrap a textbox.

--

Ken Snell
http://www.accessmvp.com/KDSnell/

"yoled333" <u59936@uwe> wrote in message news:a7c3fcc4ce560@uwe...

[John W. Vinson]

On Sun, 09 May 2010 22:18:47 GMT, "yoled333" <u59936@uwe> wrote:

>Can you tell me how to wrap text in column headings? I also need to know how
>to wrap text in a cell. Thank you.

Is this in an Excel spreadsheet (as the "cell" suggests)? If so try an Excel
forum.

If it's in an Access Table, be aware that tables are designed for data
storage, not for display or editing; table datasheets are of very limited
functionality. If you want to see data in a grid with a controllable header,
consider basing a Report on the table, with Label controls in the report
header (or its Page Header to have the headings come out on each page). To
enter a multiline label, you can set its Caption property to

first line <Ctrl><Enter>second line

holding down the Ctrl key while you press the Enter key; the same technique
works putting data into a table field.
--

John W. Vinson [MVP]