ACCESS - 255

You will only be able to do this if the Access field type is Memo, rather than Text.  For the parameter datatype in the insert command use OleDbType.VarWChar, with a size of 0.  Then the only limit will be any that is placed on user input by the control in which that happens.

Roger

Dim ConnectionString As String = "provider=microsoft.jet.oledb.4.0;" + "data source =  C:\Documents and Settings\MAX.MCCI_DOM\Desktop\MAX\bad.mdb"
        Dim Command As OleDbCommand


        Try
            'Dim Connection As OleDbConnection = New OleDbConnection(ConnectionString)
            Dim Connection As New OleDbConnection(ConnectionString)

            Connection.Open()

            Command = New OleDbCommand("insert into BadTable(Address, CityState, accurint ) values ('" & Me.txtAddress.Text & "' , '" & Me.txtCity.Text & "', '" & Me.txtSave.Text & "')", Connection)

            Command.ExecuteNonQuery()

            Connection.Close()


        Catch ex As OleDbException

            MsgBox(ex.ToString)


        End Try
    End Sub

What's that supposed to mean?

Above is btnAdd -  Me.txtSave.Text   is the only one I am questioning really. I want this filed to be able to contain more than 255 charactor. I don't understand this part  -
  For the parameter datatype in the insert command use OleDbType.VarWChar, with a size of 0. --- I thought I put this comment above my code.