<saintor1@hotmail.comschreef in bericht news:1160419511.611773.96880@m7g2000cwm.googlegrou ps.com...
Quote:
Arno R wrote: Quote:
><saintor1@hotmail.comschreef in bericht news:1160402897.853193.14910@h48g2000cwc.googlegro ups.com... Quote:
Access 97 - I want the date format YYYY-M M-DD to show everywhere.
>
My problem is that I deal with French and English versions. And don't
want to play with Windows Regional Settings.
>
In the format property of a control, it is easy to enter YYYY-MM-DD
>
But it won't work in French versions. In them, AAAA-MM-JJ will.
>
Using format(MyDate,"yyyy-mm-dd") in the controlsource doesn't sem to
help either.
>
Any solution?
| >>
>Set the format property runtime.
>>
>Private Sub Form_Open(Cancel As Integer)
>Me!DateControl1.Format="yyyy-mm-dd"
>Me!DateControl2.Format="yyyy-mm-dd"
>Me!DateControl3.Format="yyyy-mm-dd"
>End sub
>>
>Arno R
|
Some stations are running a Runtime version (no full Access installed)
. Does it change anything?
I remember an issue in the past that I could programmatically not have
Runtime version open forms in design mode. Is the format property as
the design level?
|
No need to open design mode for this.
You can change lots of property's at runtime, also with runtime versions.
This is just plain normal programming, like assigning a filter or recordset or whatever.
It will work.
However you can *not* save the design changes with a runtime version
(but you won't need to, I guess you would not even want 'them' to...)
Arno R
Date format - this has to be simple... 
