Access 2007 - Entering of datetime values in double field

[Olaf]

I have a double field (table, query or form). The field format is 'General
Date' (was set manually or by code).

Access 2003 works in the following way:
- The field shows date/time-values (i.e. "1/14/2010" for the field value
40192)
- I can enter date/time-values in the field (i.e. "1/14/2010")

Access 2007 works in the following way:
- The field shows date/time-values (i.e. "1/14/2010")
- I need to enter decimal values in the field (i.e. 40192) to obtain a valid
date. Entering of date/time-values doesn't work.

For certain reasons I can't change the field type from double to datetime.
Is there any trick so that Access 2007 can work like Access 2003 in this
matter.

Thanks for any help or hint.

Olaf

 

[Paul Shapiro]

I would fix the "certain reasons" and change the data type because it's
probably less work and less problems in the long run. If you really want to
keep the double, you could try a BeforeUpdate event on a form's textbox to
replace the entered date string with it's double equivalent. I don't think
there's anything you could do about data entry directly in a table or a
query, only on a form.