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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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?
 
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
 
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?
 
Ken,

I found the problem. There is a macro running on the On Dirty event for the
form. I combined that macro with the macro running on the After Update event
and everything is running fine now.

Thanks again for your help.

Bob
 
You're welcome.

--

Ken Snell
<MS ACCESS MVP>

Bob Boles said:
Ken,

I found the problem. There is a macro running on the On Dirty event for the
form. I combined that macro with the macro running on the After Update event
and everything is running fine now.

Thanks again for your help.

Bob
Click to expand...
 
Back
Top