One example is that you can use code to test something before you decide to
open the form/report or not. A Hyperlink has no way easy to be "cancelled".
I like the look of using hyperlinks and used them a lot in the past. The
limitations though now have caused me to abandon them entirely. What I do
now is use a label with a HyperlinkSubAdress of " " and then use code in the
Click event to do what I want. This still gives me the blue underlining and
pointing hand cursor of a hyperlink, but with none of the drawbacks.
There are some that would say "A solution that doesn't need code is better
than one that does." I would generally agree with that if the non-code
solution is not otherwise inferior. Hyperlinking around in Access apps
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com