Solved

How can I display "Some text" on a form with a hyperlink to a web page?

Posted on 2011-02-21
3
271 Views
Last Modified: 2012-05-11
I have a form with a field the stores a http address to a web site. I do not want to display the http address but the text " Open site" that would open the site when clicked. How can I do this?
0
Comment
Question by:seanlhall
  • 2
3 Comments
 
LVL 10

Expert Comment

by:VTKegan
ID: 34947030
Make a label on a form that says Open Site, and then in the Onclick event of the label, you can make it follow the hyperlink.
0
 
LVL 10

Accepted Solution

by:
VTKegan earned 500 total points
ID: 34947054
Create the Label... Label1.
Set the Caption = "Open Site"
Set the OnClick Event to something like this:


Private Sub Label1_Click()
Application.FollowHyperlink Me.httpAddress
End Sub
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 34947183

You can add or edit the displaytext part of a hyperlink field by right-clicking a hyperlink in a table, form, or report, pointing to Hyperlink on the shortcut menu, and then typing the display text in the Text to display box.

see this link

HyperlinkPart Method
http://msdn.microsoft.com/en-us/library/aa221344%28office.11%29.aspx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now