Lines in text column run together

Hi,
I'm using SQL RS 2000. My report has a text column that contains line
breaks. When printing this column in on a report, all of the lines run
together.
I've tried using a grid and list view and neither work.
Any ideas? Is there a function I should be using?
Thanks.
- JeffAre you using vbcrlf for the line breaks? I use that and it has always
worked for me.
"Jeff" wrote:
> Hi,
> I'm using SQL RS 2000. My report has a text column that contains line
> breaks. When printing this column in on a report, all of the lines run
> together.
> I've tried using a grid and list view and neither work.
> Any ideas? Is there a function I should be using?
> Thanks.
> - Jeff|||What do I do with the vrcrlf? The source application SQL RS is reading from
is a Great Plains text column. So I don't have control over how the data
enters the field. I just want to report it out.
- J
"SFrench" wrote:
> Are you using vbcrlf for the line breaks? I use that and it has always
> worked for me.
> "Jeff" wrote:
> > Hi,
> >
> > I'm using SQL RS 2000. My report has a text column that contains line
> > breaks. When printing this column in on a report, all of the lines run
> > together.
> >
> > I've tried using a grid and list view and neither work.
> >
> > Any ideas? Is there a function I should be using?
> >
> > Thanks.
> >
> > - Jeffsql