E
ExcelMan
I have a text box on a report that can contain some very long strings I pull
out of the database. The text box spans nearly the entire width of the
report and I want the string to format like a paragraph. The problem is
that the strings sometimes contain long chunks of data with no spaces and
occasional chunks with spaces. The text box seems to interpret these as
"words" and returns to the next line whenever one of these long "words"
won't fit on the line thereby leaving a lot of white space at the end of
some lines. Typical word wrap behavior. I want the text to behave more
like a paragraph that gets hyphenated, i.e., go to the end of the line each
time before beginning the next line. I don't care if hyphens get added to
the end of lines or not.
Anyone know how this is done?
Thanks.
out of the database. The text box spans nearly the entire width of the
report and I want the string to format like a paragraph. The problem is
that the strings sometimes contain long chunks of data with no spaces and
occasional chunks with spaces. The text box seems to interpret these as
"words" and returns to the next line whenever one of these long "words"
won't fit on the line thereby leaving a lot of white space at the end of
some lines. Typical word wrap behavior. I want the text to behave more
like a paragraph that gets hyphenated, i.e., go to the end of the line each
time before beginning the next line. I don't care if hyphens get added to
the end of lines or not.
Anyone know how this is done?
Thanks.