storing bold text into Database
Posted on 2002-04-09
I have a notes section in a VB form in which , the user can enter the text and there is a bold button so that user can make part of texts bold which r important . And the entire content is stored in a field "content" in Access database .i want to store the text with the bold parts so that when i reload the notes section the user sees the notes with the parts he had made bold , exactly with the changes he had made .
Now i'm thinking of only one way to store the "Selstart" and "sellength" of the rich edit text box as soon as the user selects a portion of notes and make it bold , like i'll hold 2 more fields in DB called SelStart and SelLength where i store the nos. of the bold sections , Like if the user first chooses text whose selstart is 5 and length is 20 , then another section he makes bold whose selstart is 30 and lenth is 15 , so i store 5,30,...so on (all the Selstarts ) in "SelStart" field in DB and then 20,15... so on in "SelLength" field in DB , and when i reload the VB notes form , i get these values and then split them and take 5 for first bold sections SelStart and 20 As its lengtyh adn make this bold and then i pick up 30 and its length 15 and make it bold and so on.
Is this the proper way , i mean will it not be clumsya nd leangthy ?? Can anyone tell me is there any easier way of storing a text with few sections bold , italics and all in database .