Link to home
Start Free TrialLog in
Avatar of SpencerSteel
SpencerSteel

asked on

Access 2003: Text Editor / Simple HTML formatting type tool?

Hey guys,

I've got a fairly old clunky Access/SQL Solution here which users can use to create 'adverts' for posting to various sites.

I would like to start using <b> <i> and other simple HTML formatting features, but at the moment, the text is just being entered into a simple text control.

Are there any simple plugins available that work very much like a text box, but allow simple WYSIWYG editing and returns the code ... I could probably write it manually, but I bet there's something out there that does it better !

Thanks,

S.S.
ASKER CERTIFIED SOLUTION
Avatar of Natchiket
Natchiket
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SpencerSteel
SpencerSteel

ASKER

Thanks, I'll check it ... is there a standard Control add-in I'm overlooking do you think ? I rarely use the non-standard ones and just had this thought that perhaps there's one already in the toolbox ... they never have very useful names and there's so many !

Thanks - i'll try your link as well

i'll be back ...

S.S.
No I don't think so ... I've used the lebans editor on a number of projects after having researched the subject a bit.  As far as I can tell it remains the most cost effective (i.e. free) and flexible solution for implementing simple HTML editing in an Access-based system.
it looks great - sadly the *&ASDd thing crashes on me (it goes to 'repair' everytime that 2nd form is opened) .. tried 'upgrading' the db to a 2003/2007 and resaving it ... yet for some reason it just bombs out. Must be that plugin it's using ... I will investigate.

Grrrrr

S.S.
Although I should point that web browser control is a standard ActiveX control, it's just that it can be put in an edit mode, which is what the lebans solution does.  It's just that lebans then takes this a stage further by including all the command buttons and their necessary code to provide a collection of easy to use editing tools.
cool ... that sounds perfect - someone who has done all the hard work ...

Can't work out why it's crashing on two completely different machine when it comes to that plugin ...

I'll try another download ...
You might want to try a decompile / compact repair after converting just in case something gets courrupted in the process
I tried converting it to ACC2K3 and it seems ok here.  Haven't got ACC2K7 though so I can't test that format
Solved.

For some reason I need to delete the Web Browser on the form and drop in another name, name it the same 'wbrowser', save it and we are away ....

This look GREAT ! This could save me a lot of hassle ...

You're a star ... I didn't think i'd find someone who understood my problem so quickly ...

I'm gonna jiggle this around, make it look like mine and take all the credit from the happy bosses ;)

Seriously, thanks for the lead ... 500 points well earned !

S.S.
Excellent - just what I needed. Thanks !
No worries and thanks for the points ... you might want to take some time to browse the Lebans site.  That guy is a genius.
Cheers mate ... I will.

Did you ever find a way to set the default page font ('hate Times New Roman 12!) ...

For example, in my app, a user clicks 'edit advert' and it fires up the window and copies their plain text to the HTML editor (replacing chr(13) with <br>!). It looked all horrid in the font, so I tried wrapping some basic HTML tags around the beginning and end of the editable copy, but then if a user adds a new line, the FONT tag is closed off and we revert to horrid Times ...

Just wondered if you found a way around it ?

Cheers,

S.S.
Can't say I've tried that.  My *guess* is that it will be something like
Me.WBrowser.Object.Document.execCommand "Fontname", False, "Name of your font here"
executed in the on_load event somewhere
That didn't work - but didn't bugout either ... suggesting it's close ... do you know where there's a property list for this or documentation. The only one I can find is for the newer .net version.

You're a star by the way !

Thanks,

S.S.
Actually you're right ... I just stupid put it before the 'edit' command !

Here's what I ended up with

Me.WBrowser.Object.Document.execCommand "FontName", False, "Arial"
Me.WBrowser.Object.Document.execCommand "FontSize", False, "2"
Do While Me.WBrowser.Object.ReadyState <> READYSTATE_COMPLETE ' loaded
DoEvents
Loop

Thanks again so much - it's pretty damn perfect now.