Avoid typing text in a combobox?

[lk]

Hi there,

is it possible to avoid that a user could enter a text directly in a
combobox?

The user should only select a text from the list of the combobox without
typing anything.

Thanks

LuKe

[Douglas J. Steele]

Set the combobox's LimitToList property to True. They'll still be able to
type, but their typing won't be accepted unless it's in the list.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"lk" <ce**********@email.it> wrote in message
news:3a*************@individual.net...

Hi there,

is it possible to avoid that a user could enter a text directly in a
combobox?

The user should only select a text from the list of the combobox without
typing anything.

Thanks

LuKe

[lk]

Douglas J. Steele wrote:

Set the combobox's LimitToList property to True. They'll still be able to
type, but their typing won't be accepted unless it's in the list.

Thanks for your answer.

I have already used that property.
But the problem is just the alert message.

I want to avoid the user could type in the combobox.

ByE

LuKe

[Wayne Morgan]

This would be one method. Add to the list of allowed keys as needed.

Private Sub Combo0_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyTab, vbKeyEscape, vbKeyReturn
Case Else
KeyCode = 0
End Select
End Sub

Setting the KeyCode to 0 cancels the key entry.

--
Wayne Morgan
MS Access MVP
"lk" <ce**********@email.it> wrote in message
news:3a*************@individual.net...

Douglas J. Steele wrote:

Set the combobox's LimitToList property to True. They'll still be able to
type, but their typing won't be accepted unless it's in the list.

Thanks for your answer.

I have already used that property.
But the problem is just the alert message.

I want to avoid the user could type in the combobox.

ByE

LuKe

[lk]

Wayne Morgan wrote:

This would be one method. Add to the list of allowed keys as needed.

Private Sub Combo0_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyTab, vbKeyEscape, vbKeyReturn
Case Else
KeyCode = 0
End Select
End Sub

Setting the KeyCode to 0 cancels the key entry.

THANKS!!!!!
LuKe

[stefano]

hi,

Private Sub YOURCombo_NotInList(NewData As String, Response As Integer)
Response = False
End Sub

bye,
ste

lk <ce**********@email.it> wrote in message news:<3a*************@individual.net>...

Douglas J. Steele wrote:

Set the combobox's LimitToList property to True. They'll still be able to
type, but their typing won't be accepted unless it's in the list.

Thanks for your answer.

I have already used that property.
But the problem is just the alert message.

I want to avoid the user could type in the combobox.

ByE

LuKe