Date Format Issue

I have a problem with the date format of one particular date field.
I want it to use the english UK/australian date format ie 26/10/05 and not
the U.S. format of 10/26/05.

For some strange reason, other date fields are fine... I've checked the
Format properties area of the field to make sure it is set correctly.
help.

re: Date Format Issue

"deiopajw" <g45340@hotmail.com> wrote in message
news:435f8f82$0$28421$afc38c87@news.optusnet.com.a u...[color=blue]
>I have a problem with the date format of one particular date field.
> I want it to use the english UK/australian date format ie 26/10/05 and not
> the U.S. format of 10/26/05.
>
> For some strange reason, other date fields are fine... I've checked the
> Format properties area of the field to make sure it is set correctly.
> help.
>
>[/color]
Have you done a line-by-line comparison between the properties of the
problem field and one that works? Is the problem evident at table level?

Keith.
www.keithwilby.com

re: Date Format Issue

Are you sure that you actually have a date in the problem field and not
a string that looks like a date? (If you see what I mean!!).