Can I have more than one input mask on the same field ?

[ItsMe]

Not quite sure I follow. You can place the cursor at the end of all text in the field using something like this.

If Not IsNull(Me.FieldName.Value) Then


Me.FieldName.SelText = Me.FieldName
End If

You can place the position of the cursor in a predetermined position using code like this

  If IsNull(Me.NameOfField.Value) Then
   Me.NameOfField.SelStart = 0
  End If

  If Not IsNull(Me.NameOfField.Value) Then
    If Len(Me.NameOfField.Value) < 32000 Then
      Me.NameOfField.SelStart = 2
    Else
      Me.NameOfField.SelStart = 0
   End If
  End If

THe following will delete all text after the second character, leaving the cursor just after the second character.

If Not IsNull(Me.FieldName.Value) Then
Me.FieldName.SelText = Left(Me.FieldName, 2)
End If

[giggly]

Not quite sure I follow. You can place the cursor at the end of all text in the field using something like this.

If Not IsNull(Me.FieldName.Value) Then
Me.FieldName.SelText = Me.FieldName
End If

You can place the position of the cursor in a predetermined position using code like this

  If IsNull(Me.NameOfField.Value) Then
   Me.NameOfField.SelStart = 0
  End If

  If Not IsNull(Me.NameOfField.Value) Then
    If Len(Me.NameOfField.Value) < 32000 Then
      Me.NameOfField.SelStart = 2
    Else
      Me.NameOfField.SelStart = 0
   End If
  End If

THe following will delete all text after the second character, leaving the cursor just after the second character.

If Not IsNull(Me.FieldName.Value) Then
Me.FieldName.SelText = Left(Me.FieldName, 2)
End If

Thankyou so much ItsMe I was looking at the "selstart" and did wonder if that what i was looking for but wasnt sure how to use it the way i wanted, many thanks again for your valued assistance

[ItsMe]

Sure thing. You may want to add code that would evaluate the field before executing a SelStart. If the field has saved data that the user previously inputted, you probably do not want to use SelStart. Imagine a user tabbing out of a field they just updated and then tabbing back into the field. Having SelStart automatically execute On Enter could edit data that should not be edited. Something like the Len() function combined with InStr() function may help to first evaluate the field.