I'm in the process of converting a client's Note field into a Varchar. They want to be able to apply font attributes (bold, underline, colors, etc) to the text they're entering. I have a separate Notes table that will hold multiple comments per PO#.
On my PO form, I want a tab called "Comments" that will have a read-only display of these multiple rows. Clicking on a row would bring up an individual edit form. Here's my dilemma. Is there anyway to get a multi-row display of varchar values? Rich Text controls aren't allowed in scrolling regions or DBGrids. I could load the varchar data down to a note field in a temp table for the display, but that brings with it all the extraneous format codes making the text unreadable. Anyway to do this?? Karen
