Please help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have posted before but got no responses. This must be easily fixed and
have been experienced beofre. I have a hyperlink field in a form, and I have
built a report which when run extracts the data from the current form (and
subforms) and outputs to a
report.

I have a hyperlink field which in the form view has data of "www.abc.net.au"
but when output to a report formats it as
"www.abc.net.au#http://www.abc.net.au#"

Any ideas why it formats the data like this in a report? and more
importantly, any ideas how to format the output exactly as the user inputs
it: www.abc.net.au ?

Thanks for any response.
 
Dylan

Read up on Hyperlink data type fields in Access HELP ... there are actually
three "segments" of what is stored in a hyperlink field.

For previous responses on this topic, have you searched the previous posts
in the tablesdbdesign newsgroup? Have you searched at Google.com using
hyperlink as a search criterion?
 
Hi Jeff,

To answer your questions. I have searched many forums for an answer on this,
and all areas of this forum for literally in excess of 6 hours to no avail. A
google search on hyperlink produces 4,360,000. But FYI, I have conducted a
number of searches using various search engines and various search terms for
a solution to my problem (to display the text in the hyperlink field not the
full URL) to no avail. After this I decided to post a question to the reports
forum here as I am having a problem with the display of the URL in a report.

I have read the help in Access, and am aware of the 4 parts of a URL. A
hyperlink address can have up to four parts that are separated by the number
sign (#): displaytext#address#subaddress#screentip. This however did not
anser my question on how to format the output of a hyperlink field in a
report so that it shows the display text entered into a text box on a data
entry form and not the full URL.

Thanks for your suggestions.

Jeff Boyce said:
Dylan

Read up on Hyperlink data type fields in Access HELP ... there are actually
three "segments" of what is stored in a hyperlink field.

For previous responses on this topic, have you searched the previous posts
in the tablesdbdesign newsgroup? Have you searched at Google.com using
hyperlink as a search criterion?
Click to expand...
 
Dylan

Here's a portion of Access HELP I found on topic:

Note In a field or text box that formats the hyperlink address as a
hyperlink, Microsoft Access doesn't display all four parts in the field or
control. If you want to see the whole hyperlink address, use the keyboard to
place the insertion point in the field or control (so you don't follow the
link), and press F2.

a.. If you enter displaytext, Microsoft Access doesn't show any of the
rest of the address following the display text.


b.. If you don't enter displaytext, Microsoft Access displays just the
address.


c.. Subaddress is displayed only if there is no display text or address.


d.. The ScreenTip that is displayed for a hyperlink on a data access page
is defined for the hyperlink control, so a ScreenTip that you enter as part
of the address won’t be displayed on the data access page.
When I created a new hyperlink field, filled it with the pieces, then
created both a query and a report, I only saw the "displaytext" portion.

I'm not sure what's happening with your situation...


--
Good luck

Jeff Boyce
<Access MVP>

Dylan Moran said:
Hi Jeff,

To answer your questions. I have searched many forums for an answer on this,
and all areas of this forum for literally in excess of 6 hours to no avail. A
google search on hyperlink produces 4,360,000. But FYI, I have conducted a
number of searches using various search engines and various search terms for
a solution to my problem (to display the text in the hyperlink field not the
full URL) to no avail. After this I decided to post a question to the reports
forum here as I am having a problem with the display of the URL in a report.

I have read the help in Access, and am aware of the 4 parts of a URL. A
hyperlink address can have up to four parts that are separated by the number
sign (#): displaytext#address#subaddress#screentip. This however did not
anser my question on how to format the output of a hyperlink field in a
report so that it shows the display text entered into a text box on a data
entry form and not the full URL.

Thanks for your suggestions.
Click to expand...
 
Back
Top