Date Problem Cant Seem To Work

i have this most craziest problem

date formations are in DD/mm/yyyy

now: i cahnged the field worklog_date format to dd/mm/yyyy in access and it shows formation in access as dd/mm/yyyy. Well yeppie cool.


but i am displaying this result in flexgrid how come flexgrid doesnt showthe work_date as in format dd/mm/yyyy???????

even when i asked the flexgrid to only open the table
e.g

set mainrst=indb.openrecordset("worklog")
==========
insane and stupid.

at first the sys format was changed to dd/mm/yyyy
for my query in one form


then i got user entering a date in texfield in format dd/mm/yyyy
when i view the result the flex shows the users textbox input as mm/dd/yyyy
this is killing me


can someone please help
:confused:

hi,

I created a simple form based on a simple table with a flexgrid named grdData. The first field in the table is a date/time field. i put this in my load event and it seems to work fine for me:


Private Sub Form_Load()

Dim rs As Recordset

Set rs = CurrentDb.OpenRecordset("Table1")

grdData.Row = 1
grdData.Col = 0
grdData.Value = Format(rs![theDate], "dd/mm/yyyy")
grdData.Col = 1
grdData.Value = rs![strDate]
grdData.Col = 2
grdData.Value = rs![theNumber]

rs.Close

End Sub

how u changed sys date format?

you have to change regional settings of your system according to your country then teset your flexgrid.