Ok...I have done a fair amount of searching...no luck...Originally I was trying to create a new table and change the input mask with code, no such luck.

Now I am trying to copy the MS access table(hoping to keep the input mask). I have the table copying and renaming, but it fails to keep the input mask...

So far this copies and clears the table, is there anything I am missing to make it keep the input mask

The code below is what I am using:

vb Code:
  1. Query = "SELECT * INTO [test] FROM [tblAccounts] WHERE 1=2"
  2.         comm = New OleDbCommand(Query, conn)
  3.  
  4.         Try
  5.             conn.Open()
  6.             comm.ExecuteNonQuery()
  7.         Catch ex As OleDb.OleDbException
  8.         Catch ex As Exception
  9.             MsgBox(ex.Message & vbCrLf & ex.StackTrace)
  10.         Finally
  11.             If Not (conn Is Nothing) Then
  12.                 comm.Dispose()
  13.                 comm = Nothing
  14.             End If
  15.         End Try

Thanks for any help