Forums

This topic is locked

Quite simple... but im sorry I dont know how to

Posted 08 Apr 2002 03:50:22
1
has voted
08 Apr 2002 03:50:22 Paul Erickson posted:
Hi,

What is needed or what do I need to do to to display text on screen coming from a DB to appear
the exact same way that I put it in the database. Im using UltraDev 4 on a Mac, using an Access
DB and viewing it thru ASP.
When I view a page that is pulling text from the DB it appears all bunched up no line breaks (&lt;BR&gt<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>
But when I view that same information in a update form it will display it the way it properly is.

Can anyone out there help me??, Please ??

Thanks
Pauliostro

Replies

Replied 08 Apr 2002 05:47:03
08 Apr 2002 05:47:03 Owen Eastwick replied:
When you wish to display the text complete with line breaks modify the code from this:

&lt;%= RecordsetName.Fields.Item("YourMemoFieldName".Value %&gt;

To this:

&lt;%= Replace(RecordsetName.Fields.Item("YourMemoFieldName".Value, VbCrLf, "&lt;BR&gt;" %&gt;

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 09 Apr 2002 21:27:24
09 Apr 2002 21:27:24 justin coutange replied:
Exactly what I needed to know!

I had the same problem and now it works fine!

Thanks guys
Regards
Justin
Replied 10 Apr 2002 07:09:22
10 Apr 2002 07:09:22 Paul Erickson replied:
Thanks Owen.

Works perfect, looks like you answered 2 peoples question in one hit. You champion!

Pauliostro

Reply to this topic