>>For now I just tested saving the content. I added a line at the top which was supposed to be a comment on a separate line. When I looked in SQL Server and copied text and pasted in Notepad++ I didn't see any line breaks.
>
>The content the user entered should not be altered. That would complicate things when going back in update mode. You would just need to worry about the display. If you need to support HTML from the user's data entry, then you would need a specialized control.
I don't need to support HTML. I just need to preserve line breaks (and tabs and any similar characters). In my quick test the CR was not preserved when saving our HTML into SQL Server. I'll try to debug now to see when the line break is being lost.
If it's not broken, fix it until it is.
My Blog