Hyperlink From Query in Form

[razorking]

Am sure this can be done, but have not found the right way...yet.

I have a form and the form uses a query for its underlying data. I have a field on the query that is not a field on a table, it is a concatenated field on the query. With the concatenation the result is a hyperlink (if pasted into an address bar of a browser). However I am unable so far to get it to behave as a hyperlink when displayed on my form.

If I take this same query and use it as a make table query - then change the data type on the table design to hyperlink, it works fine. Problem is I don't want that because I need it to be dynamic - meaning: if a user changes a field value on the form, the hyperlink automatically changes.

Does this make sense?? Hope I am explaining it well enough. I just need this to open a browser when clicked on and go the page specified in the hyperlink. I have the query filed displayed on a form, right now when I click it it does not open a browser. If I copy/paste it into an address bar of a browser it works perfect.

 

[liddlem]

Can you add an unbound text field (not in the query or the table) to the form so that...
On form load / current event - build the hyperlink text in code and set the value of the text field to the concatenated text.
When any one of the source fields is changed - call the same function

 

[smig]

set the IsHyperlink property of the field to true