Date Format dataagrid to Access

[Guest]

Problem: correct datagrid display of time portion of date
Setup: `1-Access dB,fld formatted as "Date- short time"
2-dataGrid col. formatted as "t"
Operation: The text an a button is created from a time portion of a
date,where when "clicked" the text modifies a dataset cell. By converting
the text to a date(Cdate()) and then via ds.dTbl(row)(col)= cDate(.text)
changes the cell contents.

results: the dataGrid displays only the date portion which is the default
date and when the daTbl is updated id dispalys the same. Note that if a
manual entry of a time portion is typed into the Access tbl cell then it
carries over and displays correctly in the dataGrid but when i try to change
the dataset and update it only displays the default date prtion.

 

[Guest]

Hi Ogetti

Are you using a form function or query
Can you let us have the full formula you are using for the data convert
which you say has (Cdate())
and it would help to have the "other bit". At the moment it seems you are
trying to change text to a date / time portion of the text and then change it
back. This can't be right so could put it very simply (I'm a bit slow
tonight)