IsHyperlink property in Access 2007

[dddsssdddsss]

I have the IsHyperlink property set to Yes for at least one control
(textbox) in every form within my application. Technically it is a
"fake" hyperlink used to navigate the user to another form within the
app and look up on this newly opened form the value within the
hyperlinked textbox. To do this I run come code behind the textbox's
onclick event. The problem in Access 2007 is that it takes forever (an
unacceptable amount of time) for the new form to open. I ran some
tests to ensure it was the hyperlink property and not something else
causing the problem.

Any ideas?

ds

 

[Ken Snell \(MVP\)]

A more usual approach is to use a command button that, when clicked, opens a
different form. Any particular reason you're using a hyperlink property?

 

[dddsssdddsss]

Ok. Scenario: a search form produces a list of search results in a grid
and one of the values is hyperlinked. Clicking on the column that is
hyperlinked brings the user to another screen which contains the
details. No different than the result set that is returned in a search
engine (except that I am showing the results in a grid). Using a
command button in this case would not be a very effective way to show
the user how to go about getting additional detail (There are lots of
applications that use hyperlinks to do this.) Without the hyperlinks,
it will become completely cumbersome to use the application.

So no ideas?

 

[Ken Snell \(MVP\)]

I have not worked with ACCESS 2007 yet, so I cannot speak to whether the
issue is that version of ACCESS or is related to something else.

You could try using the GotFocus event of the textbox to run code like this:

Private Sub NameOfTextBox_GotFocus()
Application.FollowHyperlink Me.NameOfTextBox.Value
End Sub

See if this works any differently.