Emmett That might work but this is 7.5 and I get an error trying this on Varchar.
It seems the process of changing the data type from Note to Varchar condenses the blank lines to ^ I think there are some limitations to data manipulation with Varchar in 7.5. Can't remembere exactly what they are. I plan on going to 7.6 or 8.0 but can't at this time so I will look for a work around like unloading the date, changing to Varchar then loading the data. Thanks Marc ----- Original Message ----- From: Emmitt Dove To: RBASE-L Mailing List Sent: Thursday, July 24, 2008 9:29 AM Subject: [RBASE-L] - RE: Note vs Varchar Db Memo vs DB Rich Edit Can you then try replacing your lineend characters with (char(13)) using SRPL? Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Thursday, July 24, 2008 10:17 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Note vs Varchar Db Memo vs DB Rich Edit Emmitt True but I was hoping to be able us make some text bold or use colors. If I use DB Memo on those you see all the font code.....unless I am missing something there? Thanks Marc ----- Original Message ----- From: Emmitt Dove To: RBASE-L Mailing List Sent: Thursday, July 24, 2008 8:58 AM Subject: [RBASE-L] - RE: Note vs Varchar Db Memo vs DB Rich Edit Marc, VARCHAR will still work with DBMEMO fields. You don't need the Rich Text. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Thursday, July 24, 2008 9:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Note vs Varchar Db Memo vs DB Rich Edit Hi I have a note field for storing text and I use DB Memo's on my forms. This works great the ^ Lineend gets expanded to blank lines when you are in the forms as expected. Now, I need more room so I change the field from Note to Varchar then changed the form to use DB Rich edit. Now it seems that the ^ show up instead of blank lines when in the forms. Am I missing something or am I mixing up the data type and Rich Edit? Even if I use a DB Memo in the form to edit the Varchar text I still see ^^ instead of blank lines. I have Allow Returns checked. If I an in the Rich Edit and press Enter it puts in blank likes as I want, Those seem to stick but the old ^ Lineends are not converted or expanded to blank lines so to speak. Thanks Marc
