My database is for customers details.

I have created a form in which two fields are hyperlinked. One field is the web address and the other one is the email address.

The email field is not working properly: Instead of opening the email, it opens the web page for the customer.

When I edit the hyperlink, I can see that it is linked to the box at the top saying "Existing file or web page". I can edit each customer's details one by one so that the "email address" box at the bottom is selected then I copy and paste the email address.

BUT I have 1000+ customers in this database and do not want to edit their details individually.



Question 1: Why is Access not understanding that this is an email field and not a web one?

Question 2: I would like to be able to change this setting easily and not have to edit each customer's details individually. What can I do? :?

Please help.

Thank you.