Want to bypass Date Formatting Error check

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Russ - 01 Feb 2006 17:49 GMT

I have an Access 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 down selection remains in the field. This is what we want -
either the entered date or a text 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.

Reply to this Message

John Vinson - 01 Feb 2006 23:39 GMT

>I have an Access combo box (text) field, where folks type in a shoft
>date using
[quoted text clipped - 10 lines]
>value to remain in the record? The command would be used on an "after
>update" event when the value list item is selected.

If the table field is a Date/Time field, then it CANNOT store a text
value. A Date isn't a text string; it's stored internally as a number
(a count of days and fractions of a day since an arbitrary
startpoint).

I'd question a table design which allows for a field to store two
different kinds of data (strings or dates) - fields should be atomic,
and store only one kind of data! If you insist, though, you could use
a Text field.

If I'm missing something here post back with more details about the
table and form structure.

John W. Vinson[MVP]

Reply to this Message