View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
djExcel djExcel is offline
external usenet poster
 
Posts: 17
Default Problems with long text

Hi,

I have a little program, where users enter all kind of data. In one field
they can enter a very long text (like more than 1.000 characters). Now there
is a problem when I am trying to create a report from that data. Everything
goes fine when the text is less than approx. 1.200 characters long, but with
text like 2.000 characters long, Excel won't show or print it in whole. In
the report I have both wrapped and merged range A50:H70 where I try to set
the text. I also tried to create a text box and place the text in it, but
that won't work either. The data is stored into a SQL database and I read it
when creating a report.

But the question in a nutshell: how can I show a very long text (2.000) in
a report?