Forum Moderators: phranque
I am building a site where I would like to store an text passage in a single record of a database. I am going to let the client view and edit this text as they wish. But the text consists of several paragraphs and when I store the text as a memo field in Access and retrieve it, it of course loses its paragraphs and appears as a single body. Obviously the database field doesn;t store any formatting information and other than teaching my client to use <p>paragraph tags</p> what other options do i have for storing formatting information for a text in 1 record. ( I don;t want to have a paragraph 1 field and a paragraph 2 field as there will be varying numbers of paragraphs)
Cheers
Replace( Request.Form( "text" ), vbCRLF, "<br>" )
Assuming you have CGI or some other server scripting support you can make a cheap little gui interface that displays the text formatted via DHTML in a DIV and stores it in a hidden or textarea feild down below.
On the other hand just write a FAQ and force them to grow up and learn how to make basic tags. They probably only need to know about 5 - 10 tags, something my 5 year old nephew does (you can tell them that =).
Or lastly you can always make the same little gui directly in your MS Access form and use hidden feilds for formatting in HTML tags. This however will require more programming modules and routines than the job is probably worth to you.
Good Luck
-----
David Smith
[edited by: DaveAtIFG at 5:49 am (utc) on Dec. 31, 2003]
[edit reason] Trimmed sig [/edit]
