Date Formats

[rich.barry]

I'm having some issues with date formating in a textbox.
Being from New Zealand, we use dd/mm/yy style, which is what the regional settings are set to.
The table & query my form is based on is set to this format, as is the bound text box format.

Chances are the next entry is going to have the same date as the previous entry, so I'm using the Form_Before_Update event to set the default value of the textbox to the current value.

Me!LabCutTime.DefaultValue = Format("#" & Me!LabCutTime & "#", "dd/mm/yy")

Regardless of whether I include the Format in the above line, I get mm/dd/yy appearing in the new record. It doesn't make any difference if I Format before or after adding the "#"'s.

Has anyone got any further clues ?

Richard


[This message has been edited by rich.barry (edited 06-06-2002).]

 

[expublish]

Check your regional settings on yor computer from your control panel.

HTH

Scott.

 

[rich.barry]

Ta, but checked that some time back.

 

[Rich]

Why do you have to format the date, if the property sheet and regional settings are set to short date then dates should be displayed as dd/mm/yy anyway?

 

[rich.barry]

I have tried without format, as well as with, and get the same result.

A date of 31/05/02 sets the DefaultValue correctly as the day and month are not interchangable, but 04/06/02 comes out as 06/04/02 as the Default.