|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Combo Box bypass input maskI have a combo box (text) field, where folks type in a shoft date using
an input mask <or> they select a text value from a value list. The drop eown selection remains in the field. This is what we want - either the entered date or a value from the drop down list. If you enter a date it's fine. If you select a value from the drop down list the date input mask error appears and won't allow you to save the record... Is there a VB command to bypass the input mask error and allow the text value to remain in the record? The command would be used on an after update event when the value list item is selected. And of course maybe there's another way to accomplish this without making two fields. Russ "Russ" <rleh***@npr.org> wrote in message Input mask? In VB5/6?news:1138730323.931154.87380@g44g2000cwa.googlegroups.com... > > Is there a VB command to bypass the input mask error and allow the text > value to remain in the record? The command would be used on an after > update event when the value list item is selected. > > And of course maybe there's another way to accomplish this without > making two fields. > > Russ -- Ken Halter - MS-MVP-VB - Please keep all discussions in the groups.. DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm Freeware 4 color Gradient Frame? http://www.vbsight.com/GradFrameCTL.htm "Russ" <rleh***@npr.org> wrote in message Then you should be asking in the microsoft.public.access.* newsgroup news:1138793282.461372.254030@o13g2000cwo.googlegroups.com... > Sorry, I ommitted this is an Access 9.0 db. hierarchy. This group is for the full-blown VB programming language and there are several differences between how it and Access operate.
Show quote
Hide quote
"Russ" <rleh***@npr.org> wrote in message Is there some sort of data binding going on here?news:1138730323.931154.87380@g44g2000cwa.googlegroups.com... >I have a combo box (text) field, where folks type in a shoft date using > an input mask <or> they select a text value from a value list. The > drop eown selection remains in the field. This is what we want - > either the entered date or a value from the drop down list. If you > enter a date it's fine. If you select a value from the drop down list > the date input mask error appears and won't allow you to save the > record... > > Is there a VB command to bypass the input mask error and allow the text > value to remain in the record? The command would be used on an after > update event when the value list item is selected. |
|||||||||||||||||||||||