Creating Hyperlinks in a report

[baseborn]

I know how to get a URL inserted per record via form but how can i make the URL clickable within a report ? here is my table structure and a example of what i need,

(btw this is a personal movie db im creating)

Movies Table
-------------
ID Title Category URL
1 Movie 1 Drama http://www.----.com


2 Movie 2 Comedy http://www.abc.com
3 Movie 3 Horror http://www.123.com
4 Movie 4 Thriller http://www.whatever.com

--------------------------------


So i already have a current report made out that list the Categories and the movies which they belong too, example (i also have a Categories table but im assuming most of you already know how this works)

Drama
Movie 1

Comedy
Movie 2

Horror
Movie 3

and so on..

My goal is to be able to turn the movie titles within the report into hyperlinks so when clicked on they will open up a new browser window to wherever direct.

[RuralGuy]

A Report in Access is a virtual piece of paper, not an interactive document. Maybe someone can correct me here.

[evander]

Or, how about a form, instead of a report, that contains a web browser control?

[evander]

Or, display the report in Report View, and insert code in the Click Event of a textbox to open up an Access form that contains an embedded web browser control.

[RuralGuy]

A hyperlink can launch your default Browser. Using the Browser ActiveX control is a different subject.

[baseborn]

Obviously im a newbie but im assuming i can convert the report into html so i can add it to a site. or convert it to a document and just upload it. whatever simple solution any of you may have please enlighten me! i mean it would be really nice if i could just open up my form from my desktop and add a record and it automaticly update my site but i dont know enough yet to do that. i mean i got the ODBC stuff figured out but as stated before i dont know if creating a report and then uploading it is the way to go or what. or hell just even having a form within my website where i could just login and add a record and logout.

[LarrySmithVA]

Put a text box on the report, set IsHyperlink to yes and Control Source to =[Title] & "#" & [URL] & "#" . When you open the report in report view - the Title should be displayed as a hyperlink and clicking it should take you to the URL.