Access memo field - maintaining line breaks and indents

[cosmodango]

I have spent several days on this. I hope someone can help me. I am using Acccess 2000. I have a memo field where I have cut and pasted bulleted/numbered lists from Microsoft Word. I want to display this information via asp. I have managed to get the numbers, bullets, and even skipped lines to show up by using the Replace function and vblfcr. I cannot for the life of me find out how to retain the indents. All the lines show up far to the left and do not maintain the indent, so the nicely formatted "outline" is lost and it is difficult to read.

Am I trying to do something that simply goes against the grain?

I would really appreciate help or an explanation on why this simply won't work. Is the problem when I paste into the memo field in Access or in getting the data from the field or both?

[Hargotz]

Try Replace(Memo-field,vbCrLf,"<br>") , this should work. Plenty information to find on the net for this problem

I have spent several days on this. I hope someone can help me. I am using Acccess 2000. I have a memo field where I have cut and pasted bulleted/numbered lists from Microsoft Word. I want to display this information via asp. I have managed to get the numbers, bullets, and even skipped lines to show up by using the Replace function and vblfcr. I cannot for the life of me find out how to retain the indents. All the lines show up far to the left and do not maintain the indent, so the nicely formatted "outline" is lost and it is difficult to read.

Am I trying to do something that simply goes against the grain?

I would really appreciate help or an explanation on why this simply won't work. Is the problem when I paste into the memo field in Access or in getting the data from the field or both?

[cosmodango]

Actually that's what I have in place now. I apologize for not putting that in my original post. That does a fine job of taking care of line breaks. My problem is as follows for lists as below:

1. Item one
2. Item two

• part a
• part b

When I cut and paste this into the memo field and via asp I get the following:

1. Item one
2. Item two

• part a
• part b

How do I retain the indent?

[jhardman]

Actually that's what I have in place now. I apologize for not putting that in my original post. That does a fine job of taking care of line breaks. My problem is as follows for lists as below:

1. Item one
2. Item two

• part a
• part b

When I cut and paste this into the memo field and via asp I get the following:

1. Item one
2. Item two

• part a
• part b

How do I retain the indent?

This is actually an HTML problem, All browsers ignore all white space unless you specify otherwise. What you want is something like this HTML output:[html]<ul><li>item 1</li>
<li>item 2</li>
<ul><li>part A</li>
<li>part B</li></ul>
<li>item 3</li></ul>[/html] Notice the indented list is within the first list. I don't know of anyway to do this automatically, it will take a great deal of "replace"-ing to do it correctly. You might otherwise be able to fudge something that looks right with indents and forced white space, but that always makes HTML purists groan.

Jared

[cosmodango]

This is actually an HTML problem, All browsers ignore all white space unless you specify otherwise. What you want is something like this HTML output:[html]<ul><li>item 1</li>
<li>item 2</li>
<ul><li>part A</li>
<li>part B</li></ul>
<li>item 3</li></ul>[/html] Notice the indented list is within the first list. I don't know of anyway to do this automatically, it will take a great deal of "replace"-ing to do it correctly. You might otherwise be able to fudge something that looks right with indents and forced white space, but that always makes HTML purists groan.

Jared

Thanks for the explanation...I will stop beating my head against the wall on that one.

[T Das]

Try This This works -
tmpstr is a variable

tmpstr = replace(RecSet("memofiled"),vbcrlf,"<br>")
tmpstr = replace(tmpstr," ","&nbsp;")


then

response.write "<p>" tmpstr "</p>"

your data will be printed with carriage return and white space i.e indenting.

hope this helps - d. a. s. d. i. d. e. e. n . c. o. m