Formatting in RTF Text Box

[BikeToWork]

I am using Access 2007 and have a large textbox whose TextFormat is set as RTF and is bound to a memo field. There are several command buttons which automatically insert email text into the textbox, such as Header, Signature, etc. If the TextFormat for the textbox is plain text, the carriage returns and line feeds are all inserted according to what is in the code. However, if I switch the textbox to RTF TextFormat, it ignores the hard returns in the code and just inserts its own hard returns to wrap the text. Does anyone know of a workaround for this?

[ADezii]

There is a 'long' work-a-round. Once Data is entered into the Bound Rich Text Box, you can physically insert Hard Carriage Returns (CTRL+ENTER) wherever appropriate, and the Formatting will persist. Hopefully, you or asomeone else, can come up with a 'shorter' work-a-round (LOL).

[BikeToWork]

Thanks, ADezii. I was looking for a more automated solution, if there is one. Why does the RTF text box just ignore the VBCRLF's in the code, whereas the plain text text box does not?

[Luk3r]

This may be a silly question on my part, especially because I don't know a ton about VBA, but are you able to set a multiline property for the RTB? In VB.NET, if a textbox or RTB has the multiline property disabled it will not accept carriage returns.

[ADezii]

I think that I have figured it out for you BikeToWork. The MEMO Field for a Bound Rich Text Box (txtTest in this case) appears to utilize HTML Encoding to properly Format the Rich Text contents. You need to use the HTML equivalent of a CR/LF in order to produce the same effect. Case in point:

strTest = "Test<br>String<br>for<br>BikeToWork"

Me![txtTest] = strTest

produces & preserves

Test
String
for
BikeToWork

within the Bound Rich Text Box.

[BikeToWork]

Thanks again, ADezii. You are correct about the html code for the rtf control. Access puts it in automatically when the user puts in a hard return or bolds some text, etc.

[ADezii]

You are quite welcome, so all works well?

[BikeToWork]

ADezii, unfortunately it won't work with my program. If I use <br> or <div> for new lines in the code, it will appear without the code tags in the text box but when I use the SendObject command to send the email, it shows up with all the html code tags, even if I specify acFormatHTML and select HTML format in Outlook. It was a good learning experience, though.

[NeoPa]

I believe the .Value has all the codes but if you want the text without them then .Text has that.