Update Query to change Display Value part of Hyperlink Field

[Harry Shmedlap]

Given a table field that is a hyperlink type.
I need an Update Query to set all records of that table so that the Displayed Value part of the hyperlink field (not the Address part) is set to a particular value.
Any ideas how?
Thanks.

 

[Premy]

Well, how about just adding a text field, say txtToShow, put the value u want to show there and include it in your form, or wherever u want to show it?

In the qry designer just add: ToShow: "MyWhateverText" on the field-line (new column of course) and txtToShow on the append-to-line. If u retrieve the value from a field, the field-line becomes: ToShow: [MyWhateverField]

HTH
Premy