How to use a Memo Field to get to record

[ser004]

Hi everyone,

I created a Memo Field in (Access 2010) "Hockey" database to show information on Trade/Injuries/ etc...

QUOTE

* Missed majority of 2000-01 season recovering from hand injury originally suffered in game vs. Louisville (AHL), October 27, 2000.
Traded to Pittsburgh by Phoenix with Dan Focht and Guillaume Lefebvre for Jan Hrdina and Francois Leroux, March 11, 2003.

UNQUOTE

What I'm trying to do is to just click like on a web page... example click here on a player name appearing on the Memo Field - Dan Focht and the record of that player will display.

Is this possible... Thanks in advance

Serge

 

[CJ_London]

You can incorporate a hyperlink into a memo field (by copy pasting) however so far as I am aware you can't edit it so the text display a players name rather than the full link. But google it, it may be possible.

It might also be possible using vba

you would need to have the name formatted in some way (e.g. blue underline) and using some vba in something like the mousedown or keypress or perhaps click or double click event to isolate the name from the rest of the memo using the selstart sellength properties plus identifying the end of the initial formatting code and the start of the ending formatting code.

Then having isolated the name, use it as a criteria in your docmd.openform command to open at the appropriate record

 

[ser004]

Thanks CJ_London you did direct me to a solution by using selstart & sellenght, I will investigate this further... Thanks again.

Serge