Database Discussion - Access Cell properties

Print Page | Close Window

Access Cell properties

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=9194
Printed Date: 28 March 2026 at 8:59pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access Cell properties

Posted By: jimidy
Subject: Access Cell properties
Date Posted: 23 January 2004 at 10:13pm

When I try to display my text from a cell in ASP it comes out as one long batch, if i veiw it in a text area it displays breaks and lines..

http://cms-stu-iis.gre.ac.uk/wn008/project/site/ - http://cms-stu-iis.gre.ac.uk/wn008/project/site/ then click on info

Do i need to adjust the cell properties in order for it to display returns/breaks in the page as well?

Many thanks in advance..

-------------
www.srp.me.uk

Replies:

Posted By: michael
Date Posted: 23 January 2004 at 11:48pm

Text you entered in a textbox is not "understood" by vbscript so a simple
mytext = Replace(rs("yourfield"),vbCrLf, "<br>")

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: ljamal
Date Posted: 24 January 2004 at 12:10pm

Or more accurately ...
Text entered into a text box is plain text and text line breaks (vbCrLf) need to be changed into HTML breaks (<br>).

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: jimidy
Date Posted: 25 January 2004 at 4:15am

Nice one guys this worked a peach.. Also I reversed it so in the admin section it did visa versa..

Can I make java script buttons which add text easily to a text fireld like i am writing in now as well does anyone know?

Thanks again..

-------------
www.srp.me.uk