Sytze, The valid will fire only when the combobox loses focus or when an entry is selected from the dropdown list. If you want to validate the data as you enter it then you need to use the "interactivechange" event and process the keystrokes as you get them. If you intercept the "TAB" or "ENTER" keys then you can then do the validation.
As a matter of interest what do you need to do that you can't do with the Lostfocus() or Interactivechange() events? Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sytze de Boer Sent: 05 December 2007 21:38 To: [email protected] Subject: Combo Box It must be something I'm doing (wrong) I have a combobox ControlSource=Local variable (Blank char 15) Rowsource=Winsupps (standalone table of suppliers) It seems to me the WHEN method fires fine (I tried a Wait window nowait "Testing 123" But it seems the VALID method is not working The drop down works fine bit if I type rubbish in there, the VALID method does noting What's wrong ? -- Sytze de Boer Kiss Systems Ph: 64-7-8391670 Mob:021 937611 [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
