Home All Groups Group Topic Archive Search About

Combo Box bypass input mask

Author
31 Jan 2006 5:58 PM
Russ
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.

And of course maybe there's another way to accomplish this without
making two fields.

Russ

Author
31 Jan 2006 7:48 PM
Ken Halter
"Russ" <rleh***@npr.org> wrote in message
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

Input mask? In VB5/6?

--
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
Author
1 Feb 2006 11:28 AM
Russ
Sorry, I ommitted this is an Access 9.0 db.
Author
1 Feb 2006 2:15 PM
Jeff Johnson [MVP: VB]
"Russ" <rleh***@npr.org> wrote in message
news:1138793282.461372.254030@o13g2000cwo.googlegroups.com...

> Sorry, I ommitted this is an Access 9.0 db.

Then you should be asking in the microsoft.public.access.* newsgroup
hierarchy. This group is for the full-blown VB programming language and
there are several differences between how it and Access operate.
Author
31 Jan 2006 10:04 PM
Jeff Johnson [MVP: VB]
Show quote Hide quote
"Russ" <rleh***@npr.org> wrote in message
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.

Is there some sort of data binding going on here?