Clearing the contents of unbound cells

B

Belle

I have several unbound textboxes in my form. When I move forward to view
other records in my databases the contents of the cell that I typed before
remains in the next record. How can I clear the contents of unbound cells
without changing my "DataEntry" property to Yes?
 
P

Patrick

if the data is highlited, then just run a macro that uses the SendKeys
command with the argument {BS} for backspace and that should clear it :]
 
V

Van T. Dinh

Try using the Form_Current Event to set the values of the unbound TextBoxes
to Null.
 
B

Belle

How do I highlight each control on the form without manually pressing CTRL+
the control to highlight?
 
Top