I am using CF-5 and trying to use CFGrid to edit an MS-Access 2002 SP3 table
with >60 columns of dates. When fields are defined in Access as DateTime, the
grid horizontal slide works fine but having trouble saving grid back into
Access which then corrupts the date and gives me an 1899 date in the edited
cell with time in the next row cell. Offsetting rest of cells in that row.

When I change the MS-Access fields from DateTime to Text of 20 characters in
size, edit works great. But CFgrid horizontal scroll causes the header name
row to stop scrolling at a certain column while the data rows keep scrolling to
the end.

Using Java JRE 1.4.2
Is there a fix for this in CF-5 or is this fixed in a future version, i.e. CF
MX 7.

Grid code is very simple:
<CFGRID NAME="TimeLine_grid"
HEIGHT=300
WIDTH=800
VSPACE=1
SELECTMODE="edit"
QUERY="TimeLineData"
GRIDDATAALIGN="CENTER"
ROWHEADERALIGN="CENTER"
COLHEADERALIGN="CENTER"
COLHEADERBOLD="Yes"
INSERT="No"
DELETE="No">

<CFGRIDCOLUMN
NAME="ID"
HEADER="ID"
WIDTH=50
HEADERALIGN="center"
HEADERBOLD="Yes"
SELECT="No">

<CFGRIDCOLUMN NAME="SSP_Number"
HEADER="SSP Number"
WIDTH=100
HEADERALIGN="center"
HEADERBOLD="Yes">

<CFGRIDCOLUMN NAME="Lab_Name"
HEADER="Lab Name"
WIDTH=100
HEADERALIGN="center"
HEADERBOLD="Yes">

<CFGRIDCOLUMN NAME="CISSO"
HEADER="Custodian"
WIDTH=120
HEADERALIGN="center"
HEADERBOLD="Yes">

<CFGRIDCOLUMN NAME="YesNoMasterSSP"
HEADER="Master?"
WIDTH=80
HEADERALIGN="center"
HEADERBOLD="Yes">

<CFGRIDCOLUMN NAME="Date_Created"
HEADER="Creation Date"
WIDTH=150
TYPE="STRING_NOCASE"
HEADERALIGN="center"
HEADERBOLD="Yes">

<CFGRIDCOLUMN NAME="Projected11"
HEADER="Projected Date-1.1"
WIDTH=150
TYPE="STRING_NOCASE"
HEADERALIGN="center"
HEADERBOLD="Yes">

<CFGRIDCOLUMN NAME="Actual11"
HEADER="Actual Date-1.1"
WIDTH=150
TYPE="STRING_NOCASE"
HEADERALIGN="center"
HEADERBOLD="Yes">

<CFGRIDCOLUMN NAME="Projected12"
HEADER="Projected Date-1.2"
WIDTH=150
TYPE="STRING_NOCASE"
HEADERALIGN="center"
HEADERBOLD="Yes">

<CFGRIDCOLUMN NAME="Actual12"
HEADER="Actual Date-1.2"
WIDTH=150
TYPE="STRING_NOCASE"
HEADERALIGN="center"
HEADERBOLD="Yes">

</CFGRID>