How to save formatted text to a database?
Hi all,
I have a field of text which I want the user to be able to format
ie use tabs,bold, and underline
...and when the user is finished I want to be able to display this field on another form and save this formatted text in a field in my database.
Suspect an OLE object might do the trick but have no experience with these. Any ideas or thoughts would be appreciated.
Thanks
Jonny
:D
Re: How to save formatted text to a database?
Quote:
Originally posted by JonnyCab
Hi all,
I have a field of text which I want the user to be able to format
ie use tabs,bold, and underline
...and when the user is finished I want to be able to display this field on another form and save this formatted text in a field in my database.
Suspect an OLE object might do the trick but have no experience with these. Any ideas or thoughts would be appreciated.
Thanks
Jonny
:D
dunno about saving formatted strings to tables, but you can always manipulate the data that is entered...something like if the user puts in bold text, put some kind of tag or something in the string so that you know that it's bold...ie
textbox
[<b>This is bold to the VB app, but to the table it's just varchar</b>]
then just read the tags using vb but display the text according to how it should look to the user...so parse the string and you see <b> so make the textbox bold when you see it...this might not be the most elegant way, but it'll work