Will you give me a step-by-step guide to solve this problem? I have to type dozens of records, for some of which these two fields are the same only! Is there any way that when I enter a ten digit number for field 1, field 2 is filled automatically?
By the way, do not forget that I am a NOVICE!!!
Following up on my suggestion, the key is to control all data entry through Forms. Users should rarely, if ever, be allowed to enter information into Tables directly. By using Forms, you can control data entry and set rules (like you want to do here).
So, let's say that we have this Entry Form, with fields named Field1 and Field2 (among others). Do do what you want (automatically update Field2 with the value from Field1 if it is exactly 10 characters long), go into the Properties of Field1 on your Form, go to the Event tab, go to the "After Update" property, and choose the Code Builder option. Then in the resulting VB Editor window, you will want to add code that looks like this:
Code:
Private Sub Field1_AfterUpdate()
If Len(Me.Field1) = 10 Then
Me.Field2 = Me.Field1
Me.Field2.Enabled = False
Else
Me.Field2.Enabled = True
End If
End Sub
This code should do what you want, if I understand you correctly.