Code to update field not working

[vistor]

Hi,

I have the email field properties on the form set to Is Hyperlink = Yes.

Then I have this code on the AfterUpdate event:

Private Sub Ins_Email_AfterUpdate()
Me![Ins_Email] = "#mailto:" & Left(Me![Ins_Email], InStr(1, Me![Ins_Email], "#&quot - 1) & "#"
End Sub

But it is not working. Not getting any error message generated but email stays as a http hyperlink.

Any ideas on what is wrong?

 

[vistor]

I've fixed it. Works now.