Hi there

I've created myself an Access 2007 database, and one of the columns is
a date field. When in the datasheet view and I click on the field for
the date column, I get a datepicker. In the past, this worked fine,
and would enter the date in to the field, no worries. And it would
enter it in the short date format of dd/MM/yyyy (as set for my PC).

However, a little while back, I changed the short date to also have
the first three letters of the day in it, so that the day name would
show in the clock/date field in my taskbar (the date format is now ddd
d/MM/yyyy).

However, now when I use the datepicker in the same table in my Access
2007 database, when I try to go to a different cell I get the error:
"The value you entered does not match the Date/Time data type in this
column.", and I cannot enter the date from the datepicker (note that
the datepicker now tries to enter the date as eg. Thu 07/04/2011)!
However, if I remove the 3 letters of the day name from the date
entry, I can enter it!!

How do I fix my datepickers so they work (and without changing the
short date time format for my PC)?

Cheers
Matt

Anyone?

I am going to guess that your only choice is to change back to the format you
were using.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

On 4/18/2011 9:12 PM, Matt Jensen wrote:
> Anyone?
>

Thanks for the reply John.

Thanks for the reply John.

I'm not quite certain what the problem is... a date and time field, or
variable, stores the value as a double-precision value, with the integer
part being days since 30 Dec. 1899 and the fraction representing time since
midnight. Why are you not using normal date and time and generating the
value you want using Format? Why _store_ the result of a
specifically-formatted date and time? Why require a user to enter something
you can generate for them?

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access



"Matt Jensen" <(E-Mail Removed)> wrote in message
news:4fdaa81f-a240-4c0a-ab19-(E-Mail Removed)...
> Hi there
>
> I've created myself an Access 2007 database, and one of the columns is
> a date field. When in the datasheet view and I click on the field for
> the date column, I get a datepicker. In the past, this worked fine,
> and would enter the date in to the field, no worries. And it would
> enter it in the short date format of dd/MM/yyyy (as set for my PC).
>
> However, a little while back, I changed the short date to also have
> the first three letters of the day in it, so that the day name would
> show in the clock/date field in my taskbar (the date format is now ddd
> d/MM/yyyy).
>
> However, now when I use the datepicker in the same table in my Access
> 2007 database, when I try to go to a different cell I get the error:
> "The value you entered does not match the Date/Time data type in this
> column.", and I cannot enter the date from the datepicker (note that
> the datepicker now tries to enter the date as eg. Thu 07/04/2011)!
> However, if I remove the 3 letters of the day name from the date
> entry, I can enter it!!
>
> How do I fix my datepickers so they work (and without changing the
> short date time format for my PC)?
>
> Cheers
> Matt