Making textbox null at button press

[lovett10]

Thanks in advanced for any help.

What i am trying to achieve is a button that will clear a textbox/combobox so that it has no value

button is called delQuoteNumber
Combobox is called cbrQuoteNumber

i realize that you can just highlight and delete the text and i want the button to have te same effect, i just want to make it as user friendly as possible

Im using access 2010.

 

[vbaInet]

To make your life easier you can use the Button wizard and under Record Operations you should find a Delete action.

 

[lovett10]

To make your life easier you can use the Button wizard and under Record Operations you should find a Delete action.

How do i select which box it deletes the text of?

 

[vbaInet]

I thought you said you want to delete the entire row?

When the button is clicked, the button has focus, so how does the user know which textbox he or she would like to clear?

 

[vbaInet]

I thought you said you want to delete the entire row?

When the button is clicked, the button has focus, so how does the user know which textbox he or she would like to clear?

 

[lovett10]

I thought you said you want to delete the entire row?

When the button is clicked, the button has focus, so how does the user know which textbox he or she would like to clear?

I have 2 combo boxes and 2 text boxes and each one will have a button next to it to clear the text in it.

 

[Mr Smin]

so in the button onClick event you want something like

combobox.itemselected=null
textbox=null

Sorry, I can't remember the proper syntax right offhand.

 

[lovett10]

so in the button onClick event you want something like

combobox.itemselected=null
textbox=null

Sorry, I can't remember the proper syntax right offhand.

Thanks for the help. But it doesnt seem to work. My combo box i want to clear is called cbrQuoteNumber if that helps?

 

[vbaInet]

Me.cbrQuoteNumber = Null

 

[lovett10]

Before seing that post by vbaInet i tried cbrQuoteNumber.Value = Null and it seems to work is it ok?

 

[vbaInet]

I guess so

 

[lovett10]

I guess so

Thanks very much, much appreciated

 

[vbaInet]

Glad we could help.