By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Date format - this has to be simple...

P: n/a
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?

Oct 9 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a

<sa******@hotmail.comschreef in bericht news:11*********************@h48g2000cwc.googlegro ups.com...
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
Oct 9 '06 #2

P: n/a

Arno R wrote:
<sa******@hotmail.comschreef in bericht news:11*********************@h48g2000cwc.googlegro ups.com...
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?

Oct 9 '06 #3

P: n/a

<sa******@hotmail.comschreef in bericht news:11*********************@m7g2000cwm.googlegrou ps.com...

Arno R wrote:
><sa******@hotmail.comschreef in bericht news:11*********************@h48g2000cwc.googlegro ups.com...
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
Oct 9 '06 #4

P: n/a
It worked.

But it was incredibly unproductive having to edit 100s of forms and
reports just for this.

I hope the customer will pay the 5-6 hours it took....
Arno R wrote:
<sa******@hotmail.comschreef in bericht news:11*********************@m7g2000cwm.googlegrou ps.com...

Arno R wrote:
<sa******@hotmail.comschreef in bericht news:11*********************@h48g2000cwc.googlegro ups.com...
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
Oct 14 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.