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.