Clearing field

[Blondie96]

I have a field cboStartHour which gets it's rowsource from a value list. I want to be able to clear the field if the cancel button is pushed.

Can someone help me with this?

Thanks,

Tamra

 

[HarleyQuinn]

How about:

cboStartHour = ""

Hope this helps

Harleyquinn

---------------------------------
For tsunami relief donations

 

[Blondie96]

Where would I put that?

 

[HarleyQuinn]

In the click event for the Cancel button.

Harleyquinn

---------------------------------
For tsunami relief donations

 

[Blondie96]

My mistake, I meant the ESC key. I don't have a cancel button.

 

[HarleyQuinn]

I'm sure someone can give you the code to handle the escape key, unfortunately I'm off into a meeting now. I did have one thought however, if you want to clear the list rather than just the visible text in the box try:

cboStartHour.RowSource = ""

Hope this helps

Harleyquinn

---------------------------------
For tsunami relief donations

 

[Blondie96]

Thank you Harleyquinn,

I got around the issue by adding a blank item to the value list.

Appreciate the help.

Tamra

 

[ZmrAbdulla]

Set form KeyPreview =Yes
Properties > Event > Key Preview

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    If KeyCode = vbKeyEscape Then
        If Screen.ActiveControl = Me.MyComboBox Then
            Me.MyComboBox = ""
        End If
    End If
End Sub

If you want clear the Rowsource then

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    If KeyCode = vbKeyEscape Then
        If Screen.ActiveControl = Me.MyComboBox Then
            Me.MyComboBox.RowSource = ""
        End If
    End If
End Sub

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.

 

[Blondie96]

Thank you ZmrAbdulla,

I am sure I will be able to use this code.