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.