Day,Month in date form control reversed after update of form

[Ramnik]

Hello Everyone,
I have a data entry form which have a date field.
This field retains the existing date after the record is saved with vba after update event.


Private Sub Form_AfterUpdate()
Me.ProductionDate.DefaultValue = Chr(35) & Me.ProductionDate.Value & Chr(35)
End Sub


Almost after a year of perfect working i am facing a problem.

When i save the record , in date field my date and month values are reversed if date is between 1-12.although my database stores perfectly valid date. for example
if date is "10-09-2014" (dd-mm-yyyy)
after saving form date field becomes "09-10-2014".

but if date is "13-09-2014" The date form field retains this value .

Moreover in one system this still works fine, but in other this problem occurs.
Please help

Thanks

 

[apr pillai]

It looks like your Windows 'Region & Language' settings (Date & Time settings) are changed to U.S. Format.

Do the following and check whether this is true or not:

Start --->Control Panel --->Region and Language and check the Language and Date Formats are set to the correct form that your require, if not change it, click Apply to set it.

Open Access and try to enter Dates on form to check whether it works ok now or not.

Note: The wrong dates recorded earlier must be keyed in again to record it correctly.

 

[Ramnik]

that was great . I forgot a week ago i changed the language settings thats why it happened.

Many Thanks