Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / November 2007

Tip: Looking for answers? Try searching our database.

problem with a hyperlink text box in a form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul Ponzelli - 05 Nov 2007 00:51 GMT
I'm having a problem with a text box in a form whose Control Source is a
table field that has a Hyperlink data type.  The Hyperlink addresses are
paths to folders on our network drive.  When you click on one of the
hyperlink records directly in a table or query, they work as intended - that
is, Wondows Explorer opens to the network folder designated as the Address
value of the hyperlink.

However, when I try to use the same Hyperlink field as the Control Source
for a text box in a form, the hyperlink doesn't open Windows Explorer.  The
only thing that happens is that the display in the text box changes from the
hyperlink label to the full hyperlink address.

Can anyone tell me why this text box in the form is preventing the hyperlink
field value from operating as it does in the table?  (I do have the "Is
Hyperlink" property of the form control set to "Yes").

Thanks in advance,

Paul
boblarson - 05 Nov 2007 02:03 GMT
The IsHyperlink is ONLY there to display the hand when you put your cursor
over it.  You need to add code in the click event of the text box to actually
open the hyperlink.

FollowHyperLink Me.YourTextBoxNameHere

Signature

Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

> I'm having a problem with a text box in a form whose Control Source is a
> table field that has a Hyperlink data type.  The Hyperlink addresses are
[quoted text clipped - 15 lines]
>
> Paul
Paul Ponzelli - 05 Nov 2007 07:04 GMT
FollowHyperLink works great.

Immediately after the FollowHyperLink line in the control's Enter event, I
used Me!FormName!ControlName.SetFocus to move the cursor to another control
to replace the hyperlink address in the control display with the hyperlink
label.

Thanks for your help with this, Bob.

Paul

> The IsHyperlink is ONLY there to display the hand when you put your cursor
> over it.  You need to add code in the click event of the text box to
[quoted text clipped - 27 lines]
>>
>> Paul
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.