Editing hyperlinks in rich text fields

[Dreamweaver]

I have a newsletter feature on my site but its limited so what I'm doing is creating the newsletter In a db with a mixture of rich text and plain fields my problem is when I past a hyperlink in I'm not able to edit it unless I view the field as plain text.

Does anybody know a way without code to edit the links

Thanks mics

 

[strive4peace]

hi MickJav ,

right-click on it and choose Edit Hyperlink? Oh! I just tried that and it doesn't work! let me do some exploring ...

 

[Cronk]

Store the hyperlinks in a hyperlink field. The hyperlinks can be edited in a form.

 

[strive4peace]

how about selecting it and pasting a different link? that does work

I love using the QAT and looked for an Edit Hyperlink command, but there isn't one -- seems there should be

 

[strive4peace]

I've spent some time searching and experimenting but sadly, without using VBA, I've found no built-in way!

 

[Dreamweaver]

Thanks I had the same result again Microsoft only half designed a feature lol

 

[strive4peace]

hi MickJav ,

you're welcome

Daniel Pineault has a blog article on using another editor ... but you'll need some VBA. It is here if you want to look:

MS Access - Improved HTML | DEVelopers HUT

Do you find Access' RTF to be inadequate? Do you want true HTML capabilities within your Microsoft Access database? Here how you can achieve exactly that!

www.devhut.net

 

[Dreamweaver]

I have found a way I'm creating a switch which seems to work

If Me.Txt_NewsDetails.TextFormat = acTextFormatPlain Then
    Me.Txt_NewsDetails.TextFormat = acTextFormatHTMLRichText
Else
    Me.Txt_NewsDetails.TextFormat = acTextFormatPlain
End If

 

[Dreamweaver]

The final bit selects the field and sets curser to beginning as long as there is text added

Me![Txt_NewsDetails].SetFocus
If Me![Txt_NewsDetails].SelLength > 0 Then Me![Txt_NewsDetails].SelStart = 0

 

[strive4peace]

looks like a good solution, Mick (is that your name?)

 

[Dreamweaver]

Yes yours?

 

[Dreamweaver]

I've notice when giving a link a name it no longer sees it as a link

 

[Dreamweaver]

Just sent first one when I'm finished with the tool I'll post it on my site and as always link back here

 

[Dreamweaver]

Completed my tool which works a treat couldn't quite get it working the way I wanted but works just as well.

This uses my find and replace tool but adapted for this which gets me around creating links with rich text it sends the results to a plain text field after compling each newsletter is stored in both rich text and plain that the way I wanted but can be changed with a bit of work.

https://databasedreams.createaforum.com/free-samples-and-small-projects/newsletter-242/

As Always any problems It wasn't me

 

[strive4peace]

Yes yours?

hi Mick, I am crystal

 

[strive4peace]

Completed my tool which works a treat couldn't quite get it working the way I wanted but works just as well. ...

glad you figured something out

 

[Dreamweaver]

Hi Crystal, It's had a good effect already the number of members login in yesterday was 8 which for my site is amazing at the moment

by the way I have a resources link to your site Here: look at the child boards of access central If you want a description let me know.

mick

 

[strive4peace]

hi Mick,

wow, thank you! The description I have in my signature is fine, if you don't mind adding it.

 

[Dreamweaver]

Will do

 

[Dreamweaver]

it's 3 quarters way down the list https://databasedreams.createaforum.com/access-general-center/