Solved

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

Posted on 2008-06-24
15
1,058 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
  • 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
 

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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now