Solved

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

Posted on 2008-06-24
15
1,097 Views
Last Modified: 2012-06-27
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
Comment
Question by:SpencerSteel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
15 Comments
 
LVL 17

Accepted Solution

by:
Natchiket earned 500 total points
ID: 21853765
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
 

Author Comment

by:SpencerSteel
ID: 21853776
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
 
LVL 17

Expert Comment

by:Natchiket
ID: 21853809
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:SpencerSteel
ID: 21853829
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
 
LVL 17

Expert Comment

by:Natchiket
ID: 21853838
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
 

Author Comment

by:SpencerSteel
ID: 21853844
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
 
LVL 17

Expert Comment

by:Natchiket
ID: 21853860
You might want to try a decompile / compact repair after converting just in case something gets courrupted in the process
0
 
LVL 17

Expert Comment

by:Natchiket
ID: 21853880
I tried converting it to ACC2K3 and it seems ok here.  Haven't got ACC2K7 though so I can't test that format
0
 

Author Comment

by:SpencerSteel
ID: 21853900
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
 

Author Closing Comment

by:SpencerSteel
ID: 31470073
Excellent - just what I needed. Thanks !
0
 
LVL 17

Expert Comment

by:Natchiket
ID: 21854014
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
 

Author Comment

by:SpencerSteel
ID: 21866381
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
 
LVL 17

Expert Comment

by:Natchiket
ID: 21867815
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
 

Author Comment

by:SpencerSteel
ID: 21872615
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
 

Author Comment

by:SpencerSteel
ID: 21873308
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

Technology Partners: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question