VB Forum / Database Access / June 2005

I have an Access DB and one of the columns is set to a Currency type.

I get the records into a variant array via...

If myConnection.State = adStateOpen Then
           myRecordset.Open "SELECT * FROM " & sTable, myConnection,
adOpenDynamic, adLockOptimistic, adCmdText
Else
 MsgBox "The connection could not be made."
 myConnection.Close
 Exit Sub
End If

ArrayName = myRecordset.GetRows

--------------------------------------------------------------

If I put a watch on the array it lists the value as 100  (why not 100.00)
for example and of a currency type.

If I then try to dump that values into a cell formatted to be a currency
type it lists 100 (not 100.00) as I'd expect.

The values ARE listed as $100.00 in the DB itself.

Any ideas?