How can I make a field validate itself to another field? 1

[ssnapier]

I want to be able to have to email fields and the ability to have them verify themselves against each other. How can I tell Access to do that for me?

 

[HarleyQuinn]

What is it you want to achieve when your fields

verify themselves against each other

Could you be a bit more specific?


Cheers

Harleyquinn

---------------------------------
For tsunami relief donations

 

[Reuel]

Perhaps he means he wants them to compare themselves and prompt the user if they don't match.

I created two textboxes, eMail1 and eMail2. Here's some code:

Private Sub eMail2_AfterUpdate()
    If eMail2 <> eMail1 Then
        MsgBox "eMail Mismatch."
    End If
End Sub

 

[ssnapier]

You got it right, I want to be have the ability to make sure two email address fields are the same. Where would I put that code snippet in relation to the two fields?

 

[HarleyQuinn]

Not trying to steal Reuel's thunder here...

On the AfterUpdate event of the second field (as displayed in his code above).

Harleyquinn

---------------------------------
For tsunami relief donations