When I enter a form field, all the text is deleted when I try to..

B

Bob Boles

In an Access 2002 form, all the text in a form field is deleted when I
edit/insert new text, regardless of wether I set the cursor location or just
tab into the field. My workaround is to copy the text in the form field,
paste it back in and then edit/insert text. Does anyone have an idea what's
up with this?

Thanks!!
 
K

Ken Snell [MVP]

Sounds as if you have some code running on an event of the text box, and
that code is deleting the text or selecting the entire text just before you
begin editing.

Which of the text box's events have code running on them? And what is that
code?
 
B

Bob Boles

Hi Ken,

Thanks for the reply!!
I have a macro that updates a date field in the After Update event. (This
works fine with the Access 2000 version of the database.)

Regards,
Bob Boles
 
K

Ken Snell [MVP]

What you describe should not cause this result. Describe the settings for
the properties of the text box, such as Control Source, etc. Also, what is
the RecordSource for the form? If a query, please post that SQL statement.
Also, is there any code running on any of the form's events?
 
Top