ACCESS FEED: RE: [MS_AccessPros] Format Date Field in a report to another language

Senin, 03 Desember 2012

RE: [MS_AccessPros] Format Date Field in a report to another language

Hi Jonathan

The function you want is FormatDateTimeIntl - about halfway down.

You need to know the locale code (LCID) for the country/language you want to
use.

--Graham

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jrv2110
Sent: Tuesday, 4 December 2012 13:32
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Format Date Field in a report to another
language

Hi Graham,

I looked it over and can't say I was able to spot the code for formating a
date to a specific language... But thanks for the reference. It contains a
lot of codes.

Jonathan

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Graham Mandeno"
<graham@...> wrote:
>
> Hi Jonathan
>
>
>
> Michael Kaplan (MichKa - ex MVP and now MS employee) has done a lot of
work
> on international coding. This might be enough to get you started:
>
> http://www.trigeminal.com/lang/1033/codes.asp?ItemID=7
>
>
>
> Good luck! :)
>
> Graham
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of jrv2110
> Sent: Tuesday, 4 December 2012 11:24
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Format Date Field in a report to another language
>
>
>
>
>
> Hi guys,
>
> I was wondering it there was a way to format a date field in a report to a
> specific language format without having to change the language format of
my
> operating system.
>
> Example:
>
> The current field in the report is called [date]
>
> When in the report it displays as
> (Monday, December 3, 2012)
>
> I want to change that particular form to show it in spanish as
> (Lunes, 3 de diciembre de 2012)
>
> In order to do this, what would the text box have to say in regards to
> adding to:
> =[date]
>
> Thanks in advance!
>
> Jonathan
> Running:
> Microsoft Access 2010
> Windows 7 Ultimate
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]