email link in field only working on 1 of 3 forms on same database

[Nkosi]

Hello,

My first post.

I have a database to control stock incoming and outgoing. The database has a form for suppliers, staff and vessels. each of these forms has a field for an email address. The staff one works fine when you click on the field it opens a new email in outlook. Unforunately the other two forms it just adds a mailto: text next to the email address. I am sure I did nothing different when I created the tables and forms. Tried again and now all staff email links work but not on the other tables.

Any ideas?

[zmbd]

+ Version of Office/Access?

+ For the forms, are they using the same table/query for the record source?
+++ If using more than one table, are all of the emails the same between the tables?

+ In the table what is the field data type in the table(s) associated with the control(s)? Please open the table(s) in design view and "lay eyes on" the field definition - again yes please :) .

+ Please open the form(s) in design view, show the property of the field control(s), event tab, on_click event - is there code (either VBA or Macro-Script) set for these controls? If there is code, verify that the code is properly scripted for the control(s) in question.

[Nkosi]

I found the answer, an after update sub was bugging it, once removed as it was not really necessary email link worked fine

[zmbd]

it's the little things that can drive one crazy :)