Help with hyperlinks in MS Access Report

[MChancellor]

Hi!

I was wondering if anyone would happen to know how to fix a problem I am having.

When I enter information into a field as a hyperlink, and then that field is on a report, it shows up as www.nameofwebsite.com#

http://www.nameofwebsite.com#

- is there any way to get it where only "

http://www.nameofwebsite.com

" shows up, without the part between the # signs?

Please let me know if there is a way to fix this.

Thanks,
Misti

 

[Databaseguy]

That's because in your table, that's how it's stored.You just can't see the #part#.

Use this

HyperlinkPart([YourField],1)

 

[MChancellor]

Thanks!

Once I put it in a calculated text box, it worked perfectly.

Thanks, again.
Misti