Retain memo format - Require WYSIWYG (1 Viewer)

[alcifer_c]

Memo field data like this:

this person on this day said:
blah blah

this other person on this day said:
so on and so on

I have created an email that takes the memo field and puts it into a table. In my table the memo field removes all formatting and displays as one block of information.
Ie. this person on this day said:blah blah this other person on this day said: so on and so on

I would like to retain the same formatting so that the info displays as it is in my memo field.

Your assistance appreciated with this, has been driving me crazy!

 

[KenHigg]

I'm guessing it's on the html side where the spaces are being removed...

Maybe you need to put <div></div> tags around it...

???

 

[alcifer_c]

Don't think it's related to the html...but??

The code I use is this:

strolbody = strolbody & "<tr> <td>Ticket Text</td><td>" & me.notes & "</td>"

It's the me.notes that needs to retain the formatting. Sorry the tags you suggested didn't change anything. I'm no tagger though, not sure what that would do.

Thanks!

 

[reclusivemonkey]

The code I use is this:

strolbody = strolbody & "<tr> <td>Ticket Text</td><td>" & me.notes & "</td>"

It's the me.notes that needs to retain the formatting.

Try

strolbody = strolbody & "<tr> <td>Ticket Text</td><td><pre>" & me.notes & "</pre></td>"

The <pre> tags should preserve formatting, although whether or not it will work through access I am not sure. Here's a link to PRE on w3schools;

http://www.w3schools.com/tags/tag_pre.asp