Text does not fit within cell

[oggsta]

I have a cell that contains allot of data, up to 1500 characters. The spreadsheet cell does not show all the text, and cuts off at a point where the row height is 152.2. If i increase the row height there is gap at the top of the cell but the text still cuts off down the bottom. The cell should wrap but does not for some reason.

Incidentally the report has been generated from excel.

Does anyone know why this is happening? If not I may need to enforce a character limit in my access field, does anyone know how to incorporate this in an access database.




Any help appreciated, Thanks

 

[Mike Lewis]

Oggsta,

You refer to a cell and a spreadsheet. Are you talking about grids? If so, you might try placing an edit box in the cell, rather than the default text box. In general, an edit box is better for large chunks of text.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[Wray69]

XL: Only 1,024 Characters Are Displayed in a Cell (211580)
The information in this article applies to:
Microsoft Excel 2000
Microsoft Excel 2002

This article was previously published under Q211580
For a Microsoft Excel 97 version of this article, see 156881.
For a Microsoft Excel 2001 Mac Editiona and Excel 98 Macintosh Edition version of this article, see 180278.

SYMPTOMS
If a cell contains more than 1,024 characters, or if it contains a formula that returns a result of more than 1,024 characters, only approximately the first 1,024 characters are displayed in the cell.
MORE INFORMATION
In the versions of Microsoft Excel listed at the beginning of this article, a cell can contain up to 32,767 characters. However, if a cell contains more than 1,024 characters, the following rules apply:


Characters after approximately the 1,024th character do not appear in the cell; however, they appear in the formula bar when you edit or select the cell.
Although characters after approximately the 1,024th character do not appear, you can detect and manipulate them with worksheet functions (for example, the RIGHT and MID functions) and macro commands (for example the Characters property).
If you copy a cell that contains more than 1,024 characters, and then paste them in another cell, all of the characters are pasted into the new cell. However, characters after approximately the 1,024th character do not appear in the destination cell.
Characters in a cell after approximately the 1,024th character are not printed and may not appear in print preview.
NOTE: You may be able to see more than 1,024 characters by increasing the row height and column width of the worksheet, or by modifying the display settings of the system.

Regards,

Wray

 

[Mike Lewis]

Sorry. Ignore my message. I was in the wrong forum.


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[LarryDeLaruelle]

Perhaps this should be a new thread, but it seems to follow this discussion.

I am exporting an Access Query to Excel (by e-mail as a Excel attachment). One of the fields is of type Memo. Only the first 255 characters of the memo field are visible in the Excel cell.

According to MS KBA 213910 "When you use the Pick From List" option . . . you are limited to 255 characters . . ."

This really does not seem pertinent since I am not (I don't think) using Pick From List although the autocomplete feature is turned on (turning it off does not seem to make a difference). I was not able to find any other KBA that addresses this issue. Of course, that is to be expected, MS Help is not.

Is there another, 255 character, size limit on text cells?

Is there something else I need to do to make the entire contents of the Access Memo field to display? (Short of writing a function to parse the field.)

Thanks.

Larry De Laruelle
ldelaruelle@familychildrenscenter.org