MS Access, Memo Return Breaks?

[trocat]

I am building a backend to a web site that allows the owner to update their
text. I am having a problem getting the return breaks to display on the web
page. E.g., when they type 3 paragraphs of text and submit, the text get
crammed into one big glob of text. That's how it diplays on the public page. In
MS access, how do I specify it to recognize returns? As always. your help is
appreciated!

[rob::db]

You need a function that converts line breaks into HTML <br /> tags, or into
a set of HTML <p> tags. This is pretty much the most basic problem out there
when dealing with submitted text, and there are plenty of pre-build
solutions out there with varying levels of complexity. PHP, for example, has
a built in function for handling this called nl2br, and the language you're
using probably has one too.

You can call it either when submitting the text (so the HTML tags are stored
with the text in the database), or when the public page loads, which is
easier but less efficient.

Rob


trocat wrote:

> I am building a backend to a web site that allows the owner to update
> their text. I am having a problem getting the return breaks to
> display on the web page. E.g., when they type 3 paragraphs of text
> and submit, the text get crammed into one big glob of text. That's
> how it diplays on the public page. In MS access, how do I specify it
> to recognize returns? As always. your help is appreciated!

[trocat]

Rob,

Thanks for the post. I found the solution right here at Macromedia. Tech note
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16725[/url]. As I
thought it's real simple:

ASP with VBScript
Find the Dreamweaver-generated code that displays the data field on the
page:


<%=(myRecordset.Fields.Item("myField").Value)%>

Modify the code as specified below (code should be contained all on one
line):


<%=Replace(myRecordset.Fields.Item("myField").
Value,Chr(13),"<br>")%>

Thats it!

[rob::db]

Aye, as I said, it's just a built in function to replace line breaks (char
13), with <br /> tags. One thing to note is that the tags there are just
<br>, not <br />, which means they're not XHTML compatible.


trocat wrote:

> Rob,
>
> Thanks for the post. I found the solution right here at Macromedia.
> Tech note
> [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16725[/url].
> As I thought it's real simple:
>
> ASP with VBScript
> Find the Dreamweaver-generated code that displays the data field
> on the page:
>
>
> <%=(myRecordset.Fields.Item("myField").Value)%>
>
> Modify the code as specified below (code should be contained all
> on one line):
>
>
> <%=Replace(myRecordset.Fields.Item("myField").
> Value,Chr(13),"<br>")%>
>
> Thats it!