Duplicate a record + paste errors + input mask

[malibudude]

Hi there,

I've got an access form with customer data and I've added the duplicate a record button. However, I have 2 fields that capture phone numbers that use an input mask and I've narrowed it down to why the duplicate fails.

The input mask is !\(999") "000\-0000" ext "99999;0;_ which works on the form perfectly, however, the duplicate function barfs at it.

Any ideas other than to remove the input mask?

Thanks

 

[missinglinq]

I have to say, that is bizarre! But I use this code for copying records, and it works correctly, not producing the error when using your Input Mask:

Private Sub CopyRecord_Click()
  If Me.Dirty Then Me.Dirty = False
  DoCmd.RunCommand acCmdSelectRecord
  DoCmd.RunCommand acCmdCopy
  DoCmd.GoToRecord , , acNewRec
  DoCmd.RunCommand acCmdPaste
End Sub

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!