Clearing controls in access forms 2

[lvengineer]

Hello,
My first database form uses a "clear" command button to clear text boxes, etc.

VB6 code for this is txtName.txt = ""

Is it the same in VBA for access?

Also, how would you write a line of code to clear a combo box?

Thank you in advance,
Bruce

 

[ReluctantDataGuy]

For clearing text boxes, it depends...

If your text box is unbound, then

txtName.txt = ""

should work just fine. If, on the other hand, the text box is a bound control, then it depends on the datatype. Some datatypes require "" and other datatypes require Null.

For combo boxes, you use the RowSource property.

In this case, it doesn't make any difference whether its a bound control or not.

cboMyComboBox.RowSource = "" works whether the RowSource is a Table/Query, or a Value List, or a Field List.