PDA

View Full Version : database question


gcapp
09-04-2002, 06:24 PM
I have a simple question that hopefully someone can answer.

When you put text into an Access database field (data type of Memo), can you have it where the output text has new paragraphs?

More exact - if you go to this link:
http://www.enchantedmountains.info/asp/culture-result.asp?MuseumID=1

you will see a body of text describing a museum. That text is in a field in an Access database. Is there a way that I can get that text to separate into paragraphs without creating another field in the database? Can you put in html tags into the text and it will be read??


If someone can help - I'd appreciate it.

Gary

Roy Sinclair
09-04-2002, 07:34 PM
As long as you aren't expecting to use that same text outside of web pages then putting a little html into it won't hurt. If you are expecting to use that same text outside the web then use the CRLF characters to create line breaks in the text and then when you write the text to the page you can use: Replace(TextOfArticle,vbCRLF,"<br />") to turn those CRLFs into line breaks as the page is written to the web.