I need an email adress field in my db so I created a field with the hyperlink property. I have a form where the user can input his email adress. However, Access interprets it as a website url and not as an email. The solution would be to append "mailto:" before the email adress but I do not want this to be visible.
So, I thought I'd do some preprocessing before the record is saved and use the beforeupdate event to set the hyperlink.adress and hyperlink.texttodisplay properties. However, this gives me some read-only errors.
How can I solve or circumvent this little annoyance ?