Hyperlink fields

[silverback]

What is stored in a hyperlink field is different from what one sees. E.g. silverback@hotmail.com is actually stored as silverback@hotmail.com#mailto:silverback@hotmail.com#
We have a problem in the DB we support because an email address has been corrupted somehow.
Is there a way to construct a query that will list the actual contents of the hyperlink field rather than just the email display portion, please?
Thanks
Silverback

[HansV]

1) You can right-click the value that doesn't work, and select Hyperlink > Edit Hyperlink from the context menu. This will let you edit both the Address (the target of the hyperlink) and the 'Text to display'.

2) To see the actual contents, you can temporarily change the Data Type of the hyperlink field to Memo (or Long Text in recent versions of Access). After inspecting and if necessary editing the contents, change the Data Type back to Hyperlink.

3) If it's just for display purposes, you can create a calculated field in a query. For example, for a field named Email:

[Email] & ""

Calculated fields cannot be edited, however.

[silverback]

Thanks, again, Hans
Option 2 is just what we need. Now we can create a query to list all the people who've joined after the last successful run of DB option and look at the email field which we suspect is causing the option to DB fail.
More choccie bars for Easter!
Silverback

[HansV]

Thanks!