HI I need this to get my users to update to 7.6 or 8.0. This one form is a major part of my app.
My current app in 7.5 uses a Note field and DB Memo. I look up text from another table and put it into the DB Memo field. All the paragraphs keep their format with blank lines between them. In 7.6 I changed the Note field to Varchar and I loose the blank lines between the paragraphs and get the LineEnd character. I tried DB Memo and Rich Edit both loose the blank lines. The Note field DB Memo works fine in 7.6. Many of my users need more that 4k for their notes so I want this to be a reason form them to update but they will want the same blank lines between paragraphs. I look up the var .vadjdesc37 from another table When I do show var .vadjdesc37 it shows the blank lines between the paragraphs but when used in the form both paragraphs and together. UPDATE Table SET subjx = (subjx + .vadjdesc37 + ' ') + WHERE ......... If we could expand Note fields to 12K that would work too. Any thoughts on what I am missing? Thanks Marc

