Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1113
  • Last Modified:

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.
0
SpencerSteel
Asked:
SpencerSteel
  • 8
  • 7
1 Solution
 
NatchiketCommented:
There's an HTML editor which uses the web browser control available from lebans
http://www.lebans.com/htmleditor.htm
This is an ACC2K implementation but I guess it should work fine for 2003
0
 
SpencerSteelAuthor Commented:
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.
0
 
NatchiketCommented:
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.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
SpencerSteelAuthor Commented:
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.
0
 
NatchiketCommented:
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.
0
 
SpencerSteelAuthor Commented:
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 ...
0
 
NatchiketCommented:
You might want to try a decompile / compact repair after converting just in case something gets courrupted in the process
0
 
NatchiketCommented:
I tried converting it to ACC2K3 and it seems ok here.  Haven't got ACC2K7 though so I can't test that format
0
 
SpencerSteelAuthor Commented:
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.
0
 
SpencerSteelAuthor Commented:
Excellent - just what I needed. Thanks !
0
 
NatchiketCommented:
No worries and thanks for the points ... you might want to take some time to browse the Lebans site.  That guy is a genius.
0
 
SpencerSteelAuthor Commented:
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.
0
 
NatchiketCommented:
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
0
 
SpencerSteelAuthor Commented:
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.
0
 
SpencerSteelAuthor Commented:
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.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now