How do I update address of hyperlink field in Access via query?

[Guest]

I've created a new field in an existing Access table to store hyperlinks.
The hyperlink is a concatenation of other fields, so I'd like to use an
update query so I can batch update each of the records (there are thousands).
When I run the query, the text of the hyperlink is updated, but the address
doesn't update, so I don't go anywhere when I click on the field.

 

[[MVP] S.Clark]

Unfortunately, I don't think that Access Queries(or any SQL for that matter)
knows that hyperlinks exist. So, you will probably have to do something in
code to set the specific hyperlink properties for the field for each record.

You wouldn't happen to be Steve Bell of Warren, OH would you? If so, then
think TightSqueeze.