Excel will only display approximately 1024 characters in a cell (even merged
cells). It may vary from this total because the characters will display
until they reach the right edge of the cell (or merged cells)

You can overcome this by putting forced returns in your text. So go near
the last part of your text that is displayed and manually do alt+enter.

This should then cause more text to be displayed.

To do this in code, you have to use Chr(10)

So in the VBE if you had

sStr = "abcd" & _
"efgh" & _
"ijkl" & _
"mnop" & _
"qrstuvwxyz"

you would need to do

sStr = "abcd" & _
"efgh" & _
"ijkl" & chr(10) & _
"mnop" & _
"qrstuv" & chr(10) & _
"wxyz"

Also, you would need to format your box for word wrap.

--
Regards,
Tom Ogilvy


"Ren" wrote in message
...
Greetings to all

I have a form that I created, in that form I also have a box that consist
of
a few cells that I merged together and also given a certain height and
with
the help of Tom and Sharad was able to fit my biggest text.

I was able to fit the entire paragraph in all the boxes. That was with
the
English text, now I have to do the same with the French text and I'm
having a
problem. The French version is always longer then the English.

So I broke the paragraph into section like Tom and Sharad suggested and
for
some unknown reason the last part of the text those not want to wrap to
the
next line, it continues to the edge of the box then disappears.

What am I doing wrong? Even if I reduce the font I get the same problem
the
last part of the paragraph will not wrap to the next line.

Thanks for your HELP!!