Mark A Matte
markamatte at hotmail.com
Fri Feb 11 09:04:25 CST 2005
Hello All, I must be misunderstanding the request...couldn't you just use the 'LimitToList' property? Thanks, Mark >From: "Gustav Brock" <Gustav at cactus.dk> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: <accessd at databaseadvisors.com> >Subject: Re: [AccessD] Access Combo Box - Stop Text Entry >Date: Fri, 11 Feb 2005 14:18:46 +0100 > >Hi Paul > >You can use this - which also blocks Alt+ArrowDown and Ctrl-V, thus no >selecting or paste by keypress while mouseclicks still works. > >Private Sub cboTestCombo_KeyDown(KeyCode As Integer, Shift As Integer) > > KeyCode = 0 > >End Sub > >To block mouse right-clicks too: > >Private Sub cboTestCombo_MouseDown(Button As Integer, Shift As Integer, >X As Single, Y As Single) > > If Button And acRightButton = acRightButton Then > Button = 0 > End If > >End Sub > >/gustav > > >>> paul.hartland at fsmail.net 11-02-2005 13:16:40 >>> >To all, > >I have a combo box on a form with a list of five entries, I want to be >able to make the user select from the list, but not be able to type in >the box is there anyway of doing this > >Thanks in advance for any help on this. > >Paul Hartland >Website: http://www.databaseadvisors.com >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com