Thank you for helping me with the code. I will give this a try when I return to 
the office.

Joe

--- In [email protected], "Liveson Tumbulu" <l.tumb...@...> wrote:
>
> Sorry I hit Send button accidentally
> 
>  
> 
> You can set the fields' Input Mask to Password if you want to conceal
> whatever is entered in the fields.
> 
>  
> 
> HTH
> 
>  
> 
> Liveson
> 
>  
> 
> From: [email protected] [mailto:[email protected]] On Behalf
> Of Liveson Tumbulu
> Sent: Monday, 29 March, 2010 10:47
> To: [email protected]
> Subject: RE: [ms_access] Data Validation on the form
> Importance: High
> 
>  
> 
>   
> 
> Joe
> 
> This should work whether in Access 2007 or earlier. If I get your question
> right here is what I think you need to do assuming you are familiar with
> Visual Basic for Application (VBA).
> 
> In DL2's BeforeUpdate event put this code
> 
> If DL2 <> DL1 Then
> 
> DL1 = Null 
> 
> DL2 = Null 
> 
> Cancel = 1
> 
> DL1.SetFocus
> 
> End If
> 
> The above code will clear whatever was entered in DL1 and DL2 if it is found
> that the two are not the same.
> 
> You can set the fields' 
> 
> HTH
> 
> Liveson
> 
> From: [email protected] <mailto:ms_access%40yahoogroups.com>
> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> ] On
> Behalf
> Of feihu_aiwei
> Sent: Sunday, 28 March, 2010 18:29
> To: [email protected] <mailto:ms_access%40yahoogroups.com> 
> Subject: [ms_access] Data Validation on the form
> 
> I am working in Access 2007 and creating a database to keep track of our
> volunteers for our C.E.R.T. Group. There is some information that I am
> requesting that is semi confidential, so when it is entered, I don't want do
> display it on the screen, but I need to make sure the first field is
> identical to the second field.
> 
> The end user only has access to the forms. My query is built off my table.
> 
> The field names that need to be compared are: DL1 and DL2. Once focus is
> removed from DL2, I want to compare both fields to make sure they are
> identical. If they are not, I want to clear both fields and return focus to
> DL1. 
> 
> How can I accomplish this? I am sure I need to do my validation on the form,
> but not sure how. 
> 
> Thanks
> 
> Joe
> 
> [Non-text portions of this message have been removed]
> 
> 
> 
> 
> 
> [Non-text portions of this message have been removed]
>


Reply via email to