Time Format

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

Hi, I have a cbo field which list values are the months
January, February, .. etc. I need to set the default value
to the current month, using:
Format(Date(); "mmmm")
The problem is that the computers language is german, so
instead of having March set as default it displays März..
Who can I force it to display the US Standard?

Thx.
 
Most of the built-in functions use the user's Locale information. If you
want to guarantee you're returning English, build a table that contains the
12 month numbers and the associated text, and use it.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


Hi, I have a cbo field which list values are the months
January, February, .. etc. I need to set the default value
to the current month, using:
Format(Date(); "mmmm")
The problem is that the computers language is german, so
instead of having March set as default it displays März..
Who can I force it to display the US Standard?

Thx.
 
Back
Top