Report with hyperlinks to Internet

[mchao]

I have a table with two fields:
News_head (Text)
News_URL" (Text)

I want make a report with a "News_head" fields hiperlink to internet with the News_URL data...

I don't want to show explicity in the reports the fields News_URL..

Somebody can help me?

Thank you,

[liimra]

Solution/

There is a funny solution but it works.

The Url Field is called "News_URL", so you add new text field to your report (same size as for the header field) and you put right on top of the other one (You paste "News_URL" without quotes inside it - I suppose that News_URL is already in the record source of the report). Then, you change the Foreground Color to White and change the Fontsize to 1. That is it, the URL won't appear and when you click on the Header field you are actually clicking on the URL field. You might want to add

Me.Requery

to the On Click event as the field might disappear.


Regards,
Ali

[mchao]

Good idea...but...

Thank you, is a good idea, but I have a problem...
If I set the field "News_URL" on top in the report, I can't see the data of News_head...and if I set News_head on top, the link of News_URL behind does't work..
:-(

[liimra]

Solution/

Did you change the backstyle of the field to transparent? That is it and you are done.


Regards,
Ali

[liimra]

//

Did it work?

Regards,
Ali