Memo String display/printing help

What I'm using:
ASP Pages
Microsoft Access 97
Microsoft FrontPage 2002


I am designing a website and integrated database for my company. In one of my pages I print out a report in which there are many text fields. I create a query and populate an html table based on the results. A major problem I am having is that when I output a memo string to a cell all of the returns that have been recorded in the string show up as spaces. I know that the returns are indeed there, evidenced by printing out correctly in Microsoft Access.

I need to find a way to recognize the returns, because this page is intended to be a somewhat formal report. Any help on this matter is greatly appreciated.

Dan Price
Long Island, NY

The first thing you are doing wrong is using Access 97 and FrontPage :-) just kidding but seriously your company should think about ajusting to today's time but that's just my opinion!

---BEGIN QUOTE
In one of my pages I print out a report in which there are many text fields
---END QUOTE

Question:
Are these <textfields> populated WITH data coming from YOUR database?
OR
Are these <textfields> blank?



Then...you say
---BEGIN QUOTE
I create a query and populate an html table based on the results
---END QUOTE

Question:
What results ?
Results from where ? the report ? the what ? the where ?

Please give us more specs.


What I think you need to do is use the Replace() functions and Replace the < br > tag with VbCrLf or something.

Search google.com for any example of replacing the "ENTER" key with proper code

Hope this helps!
Sincerely

Vlince

Sorry Vlince,
I'm actually quite the new user to both asp programming and this forum.

I'm a summer intern at a local company and I've been tasked with creating a website for my dept to be used on the company intranet using only those tools which were available

Basically, I created an html table in frontpage(to simulate a report). I run an SQL query on a access table with many fields, a few of which are memos. I then populate the cells of the html table with the results of that query. In one of the cells I require it to display a memo, which is one of the results of my query on the access Table. The problem is, the ENTER's are not displaying.

As you suggest, I'm going to invoke Google, but any additional assistance you can offer is very much appreciated.

Question:
How was the data entered in the first place? (I mean inside your database?)

Also, do you put the results inside the cell like so:
<td>...objRst("Field")...</td>

OR

do you put the results inside the control like this:
<TEXTAREA><%=objRst("Field")%></TEXTAREA>

Perhaps this information seem irrelevant but I'd like to know

I still need to know how the data go inside the database first!

Thanks

Thanks Vlince! I've actually solved the problem using your Google search suggestion.

All I needed to do was use the replace, and my code looked something like this:

MySQL=A Big Query

Set MyRs=MyConn.Execute(MySQL)
i=some number

<td><%Memo=Replace(MyRs(i),Chr(13),"<br>")%><%=Memo%></td>

As to your question, the data was entered by both online entry using the SQL INSERT INTO command and through access front end data entry.

Thanks very much for your attention to my post!