HTML Generator for a form field

I have a database storing various informtaion that is displayed on the page, now for one line or so it is fine, but i want to give th use more flexibility over what the text looks like.

Is there an extension or something i can use to make the process easier.  I am running an access 2002 database with asp pages. I know it can be done because the web wiz guide guestbook and forums use it.  Even simple things like adding bold, center and underline italic would be start.

My clients have no knowledge of HTML at all and educating them is out of the question.  I can preserve whitespace ok, just this little extra i need, thanks for you help.

To get a better idea of what i mean check out the guestbook sign page here:

or more complex:

Thanks for your time

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

log on to and search for "html formatters" or like .. i 'm sure you will find a number of scripts and you can use one according to your needs..

Actually, you can't. Not with Access. It doesn't store the text in a field that way. You can't even make it bold/italic in Access.

Go ahead, try it. Anything you do for formatting is applied to the ENTIRE field, not particular characters.

So it's not a limitation of ASP (though it's a limition of the form fields to some extent), it's a limitation of ACCESS.

>>I know it can be done because the web wiz guide guestbook and forums use it.  

But I doubt they're using Access, and I'd bet $$$$ that they're using a formatting script BEFORE they store it in the database. I would.
ThrillSeekerAuthor Commented:
Dont meant to be rude, maybe my question was not clear enough.  

I need to find some sort of formating script. I know the limitations of the access database and know for a fact (as i use it) that the data is stored in the database as HTML.  What i need is the script that writes the html for you as my client has no HTML knowlegde at all.

The public domain HTML editor is a great extension but is far too complicated and invloved.


Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.


If you add certain fields to your database tables such as:


Then you can store information.

So if you have
fldBackgroundColor = "#000000"

Then you could add the following to your page:
(And assuming you can get the recordset from the db to the page)

<table bgcolor="<%=rsFormat("fldBackgroundColor")%>">
<td style="font-size:<%=rsFormat("fldFontSize")%>pt;font-weight:<%=rsFormat("fldFontWeight")%>">This is the text</td>

A better example would probably be:

'Get your recordset here
DIM fldBackgroundColor, fldFontSize, fldFontWeight
'If no background was set then assures it is set to white eliminating nulls and errors
IF LEN(rsFormat("fldBackgroundColor")) > 0 THEN
fldBackgroundColor = rsFormat("fldBackgroundColor")
fldBackgroundColor = "#FFFFFF"
'If font size is null then sets it to 10
IF LEN(rsFormat("fldFontSize")) > 0 THEN
fldFontSize= rsFormat("fldFontSize")
fldFontSize= "10"

'If fldFontWeight is null then sets it to normal
IF LEN(rsFormat("fldFontWeight")) > 0 THEN
fldFontWeight= rsFormat("fldFontWeight")
fldFontWeight= "normal"
<table bgcolor="<%=fldBackgroundColor%>">
<td style="font-size:<%=fldFontSize%>pt;font-weight:<%=fldFontWeight%>">This is the text</td>
ThrillSeekerAuthor Commented:
Again off track.

What i want is the ability to use something along the lines of the PhBB code generator for one form field only.  What i want the user to be able to do is click on the bold button and the <B></B> tags are inserted into the the field so the user only has to put the text they want in bold in between the tags.  Same for italics, font and alignment.  Also the ability to add hyperlinks, imagae tags and colour would be nice.  I dont want to format the whole page, just the text that is going into the field.  Which will then be stored and retrieved to be displayed on part of another page.

That's all well and good, but there ISN'T any form input that will do this. NONE. If you have a standard form field, which is what you NEED to have, you can only have straight ASCII text. NO formatting at all.
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: webwoman {http:#8128858}

Please leave any comments here within the next seven days.

EE Page Editor
ThrillSeekerAuthor Commented:
I have found the answer to my question!!  Its an online WYSIWIG HTML editor!!   There is an asp.NET one that can store its HTML in a database field and upload any pictures necessary.

A search for online wysiwig HTML editor will bring up loads of options!


PAQed, with points refunded (125)

Community Support Moderator

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Dreamweaver

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.