Combo box - read only

[stuartb113 via AccessMonster.com]

Hi
Silly question time but how do i implement a Read Only Combo box on an Access
form?

I have a combo box with a specified row source. This works fine and returns
the selected rows but the user could easily overtype the value returned.
When I set the combo box 'locked' property = Yes , i am unable to select a
value from the list

thanks in advance
Stuart

 

[Brendan Reynolds]

Private Sub Combo0_KeyPress(KeyAscii As Integer)

Select Case KeyAscii
Case vbKeyEscape, vbKeyTab, vbKeyReturn
'do nothing
Case Else
KeyAscii = 0
End Select

End Sub

 

[Guest]

Change to format of the combo box to a dropdown list

 

[stuartb113 via AccessMonster.com]

Good man thanks.
That's v.useful.

Private Sub Combo0_KeyPress(KeyAscii As Integer)

Select Case KeyAscii
Case vbKeyEscape, vbKeyTab, vbKeyReturn
'do nothing
Case Else
KeyAscii = 0
End Select

End Sub

Hi
Silly question time but how do i implement a Read Only Combo box on an

[quoted text clipped - 9 lines]

thanks in advance
Stuart