hyperlink text in memo field

[GR_mahdi]

Hi
I want to create an app that works like Wikipedia. for example any word that have an explain and that's explain available in my database that word become hyperlink text with different color and so if operator click on that word open a new form and show the explain.
Any Help or idea will be appreciated.
Please help meeeee

 

[CJ_London]

problem you have is a hyperlink consists of two parts, the text you see e.g. click here and the hyperlink itself and the memo field is not sophisticated enough to hide the hyperlink.

So the only way you might be able to do it is to have a table of key phrases and related hyperlinks

then when you open the form with the memo field so vba code would need to scan the field look for each key phrase and if found, change the colour and underline - you could try using the replace function.

to activate, you use the memo click or mousedown event to detect where in the control the cursor is and if on a link, activate the hyperlink.

All in all, quite complex.

To make a start, google things like 'highlight found text in memo field' - you may find some clues as to how you can do some of this