formula to display the address of a hyperlink

[markjkubicki]

Is there a formula that will display in a form (or query) the ADDRESS of a hyperlink field ?



That is to say, I have a table with a hyperlink field (some of the links "appear" to at random loose their address portion; the displayed text portion in tack...) (This is a patch to a problem that, at the moment, I just need to make easier to deal with, so if the query is curious... i get it) To make fixing them easier, I just want to be able to see what ACCESS thinks the address is as I move thru the records (there's only a 100 or so records, not thousands...)

So I want to add to a form, that already has a textbox whose control source is [CatalogSheetLink], another textbox with the formula (below) as the control source (or more specifically, a formula that work; this one returns the dreaded #name? error)

=HyperlinkPart([CatalogSheetLink],[acAddress])

Can I get an assist on what the formula actually ought to be (PLZ)
With thanks in advance,
Mark

[ssanfu]

I ended up using the number instead of the text for "acAddress" because I used a query for the form record source.

Something like this???

[markjkubicki]

EXACTLY !!!
thnx