Pressing any key in any textbox clears a cell?

[scadaman29325]

I thought I saw this title a few weeks ago, but can't find it.

With data retrieved from a search into the form, if any key is pressed (in any textbox), I want it to clear the one textbox (or controlsource).

I tried the below, but it does not run when I press a key.

Please Login or Register  to view this content.

Thanks again for your help, Phil.

[mikerickson]

Each control has its own KeyPress event. This will clear TextBox1, but I don't see how the user can enter anything into TextBox1.

Please Login or Register  to view this content.

Perhaps this will do what you want and also allow the user to enter something in TextBox1.

Please Login or Register  to view this content.