If you want the easy way, then change the field type to a text blob, and
output it as is. Works perfectly.

The hard way is the way you have it now. To get the data you ideally
create a select stored procedure and you then need to :
find each instance of a hard return (ascii32 ?)
say HR1
copy the data from the start of the field to HR1 -1
then find hard return 2
say HR2
copy the data from position HR1+1 to this HR2 -1
and so on...
You can do it in a loop.
I'm sure others already have SPs that do this, but I take the easy route.


HTH
Alan

Alan J Davies
Aldis

On 28/06/2012 17:42, Mags Phangisa wrote:
> I have a field that takes 1000 characters. When the data is captured it is
> in paragraphs but when it is displayed in a report it comes up as a single
> (big) paragraph.
>
> Is there a way to pick up the return key so that I can display the data in
> the same way it was captured?
>
> Mags
>
> [Non-text portions of this message have been removed]
>
>