Disabling typing in a combo-box

  • Thread starter Thread starter Cameron Sutherland
  • Start date Start date
C

Cameron Sutherland

You can tell Access to ignore the error and even reset the
value entered through code:

Private Sub cboWhatever_NotInList(NewData As String,
Response As Integer)
Response = acDataErrContinue 'Ignore error
cboWhatever.Undo 'undo users typing
End Sub

If you add the undo line it removed their typing. If you
omit it it automatically drops down the combo box but
keeps their typing intact.

Will this accomplish what you are trying to do?

-Cameron Sutherland
 
I guess this would work, but it might confuse users if they type and their
typing is reset. I'd prefer the combo didn't let them type at all, only
select.
 
Back
Top