Access Displays Text Properly BUT When Emailed No Line Breaks!

[RobertIngles]

Yesterday I asked for help regarding how to achieve a carriage return when running an update query of text and merged data fields to a memo field in my table to use as the message body of an email. I used the & Chr(13) & Chr(10) & code and succeeded in having the text display propery in my form however when I email it from access it arrives as a single text string - no line breaks/carriage returns.

How do I get the message body to arrive with the same layout as I have in my form?

Thanks for the help everyone!

 

[RobertIngles]

Thanks everyone - figured it out. I needed to change the fields format in the source table as Rich Text. Works perfectly now!

Thanks