Boxes

[Guest]

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!!

 

[Tom Ogilvy]

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.

 

[Guest]

Thanks again Tom youre the MAN!!

Cheers

Ren

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.