Forums

This topic is locked

MS Access PM field - blank rows trucate on webpage

Posted 15 Nov 2001 18:15:21
1
has voted
15 Nov 2001 18:15:21 Joshua Calvert posted:
G'day!


Well, I have a detail page that displays text contained in a MS Access PM field.

When the page loads and displays the text, all paragraphs are gonners, displying all text as just one big long praragraph.

Currently I'm using Win2000, UD 4.0 and IE 5.00.2920.0000


I just can't seem to figure this one out, so it'd be very appreciated for any help there might be.


thanks,

JoshC

Replies

Replied 15 Nov 2001 19:26:38
15 Nov 2001 19:26:38 Owen Eastwick replied:
No idea what a PM field is, but here goes:

Set up a multi line text box on the form in which to enter the text and submit it to a Memo field in the database.

When you want to display the text complete with line breaks, replace this:

<% =(YourRecordsetName.Fields.Item("DatabaseFieldName".Value)%>

With this:

<% = Replace((YourRecordsetName.Fields.Item("DatabaseFieldName".Value), VbCrLf, "<BR>"%>

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 15 Nov 2001 22:28:43
15 Nov 2001 22:28:43 Joshua Calvert replied:
Thanks, Owen!


I'll give that a go and see what happens! What is trange though, is that it used to work before without any quirks when I made a similar site.

Oh btw, a MS Access PM field has the same application as a memo field.


Thanks again,

JoshC

Reply to this topic