When using the following addnew method

            With data1.recordset
                    .addnew
                    .fields (etc....)
                    .update
                    .movelast
        End with

Everything inputs fine.  The problem is that when I'm reviewing the
records, if I attempt to add or change a text box in the record, it acts
as though it is "full" of data to the allowed capacity - even though it
appears to be empty.

If I double click on the box, the blue overwrite field appears over the
entire box - as if it's filled to capacity already.

Text boxes with the 'filled already' problem changes from record to
record,  and may just be one text box or a few boxes -or all - there's
no 'specific - consistent' problem boxes.
One record may have no problems at all - any and all text boxes can be
changed/updated  - but the next record may have several text boxes that
act as if they're already filled to capacity.

Any thoughts?  Any and all help will be appreciated -  here or Email is
fine.

Thanks.

John

Sounds like, for whatever reason, you're filling those textboxes with
long strings of space characters. Assuming the textbox is bound directly
to a data control, that means the database field itself contains a long
string of space characters.

If you want to keep the textbox bound, you can go into the database and
clean up the fields with the extraneous spaces. You could, though I
haven't tried this so I don't know what all the side-effects will be,
put something in the box's Change event like:

   Private Sub TextBox1_Change()
     With TextBox1
       .Text = Trim$(.Text)
     End With
   End Sub

Also, before the data control updates the database, you can use its
Validate event to trim extra space characters.