Msflexgrid Saving to database problem

[Cheyenne]

I've got a problem with my msflexgrid1 while attempting to save the data
to the database.

I get an datatype conversion error...but I can't figure out why. I aslo dont
understand the big numbers that I get while looking at the msflexgrid1.text
value.

HElp!!!!!!!!!!!

Please offer some thoughts!!


If I leave my cursor/mouse on that erorr line I get the value for msflexgrid1.text
which is a hudge number: 11753595471532175421000000000000000000000000000000000000 . . . .

Private Sub Command4_Click()
'save button CODE IS BELOW ?>  > >
 
'declare local variables . .
Dim r As Integer
Dim t As Long
 
myrs.MoveFirst
For r = 1 To MSFlexGrid1.Rows - 1   ' cycle thru the rows
myrs.Edit      ' this opens the recordset record to be opend to be edited
MSFlexGrid1.Row = r
For t = 0 To myrs.Fields.Count                'cycle thru the fields/columns
MSFlexGrid1.Col = t
myrs.Fields(t) = Format$(Val(MSFlexGrid1.Text))             [COLOR=royalblue]Error Here::3421 Data Type Conversion Error[/COLOR] 
 
Next t
myrs.Update
myrs.MoveNext
Next r
 
end Sub