Display a French Date

[Derek Pierce]

I have a report letter in english and french, but want
autoformat date to be displayed in proper french. Is
there coding that I can add to the Text Box that will
allow for French date??

 

[SA]

Derek:

Use the format() function to control how the date is displayed in your
report, setting the control source for the data =
Format([YourDateField],"ddmmyyyy"). Keep in mind that if the control name
and the control source (i.e. the current field name) have the same name,
then you need to alias the name of the control (add any simply suffix) to
avoid a circular reference when you use a function like Format in your
control source.