show only filename from hyperlink

[Ruzz2k]

hi is it possible to browse to a file add it as a hyperlink and then click ok
and then using the afterupdate event change the text to display to just the filename rather than doing it manually.

Second question can I take a query with a field which is text and a field which is hyperlink and have a calculated field which displays as the text but is the same hyperlink that the hyperlink field is.

Thanks

 

[abubasil]

Yes it is possible as long as the hyperlink is nothing more a string , you need to deal with String Functions:
as for the second question, simply put a label and set the hyperlink address property to the desire link in its properties window