RE: datepicker and dateformat

Weird, the problem is gone and i haven't done anything fundamental.
Must have been a glitch in access ?!


thx for anyone reading my post
regards

Ward




"Ward Germonpré" <king.albert2@xxxxxxxxxxxxxxxx> wrote in
news:Xns986565FB2B2B7kingalbert2forpresid@xxxxxxxxxxxxxx:

Thx for replying Damian,


but that is exactly the problem.
This date is read from the database and diplayed in a listview object
first, and when the user clicks a button this date is then exported
from the database to a csv file, which means I have to intervene twice
in vba to format it to ddmmyyyy. I can manage that, but had
hoped/expected Access to do that for me.

Any suggestions ?

thx

Ward


=?Utf-8?B?RGFtaWFuIFM=?= <DamianS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:2796ACA8-216C-4193-869A-746A542D9B7C@xxxxxxxxxxxxx:

HI Ward,

The date format you display has nothing to do with how the date is
actually stored in the database table. Simply format it the way you
want it displayed and let Access worry about how it's stored.


Hope that clarifies it for you.

Damian.

"Ward Germonpré" wrote:

Hi,

I have a datepicker on a form.
The selected date is stored in a table.
The format of that date field is 'short date notation'.

Unfortunately that doesn't work: both date AND time are stored.

I setup the datepicker object with dtpShortDate. This, combined with
the field format should yield a date only, no ?


thx for any help


Ward




.