need help getting data with vb6 from access db after there is a space

[hoggle]

I'm doing a "SELECT * FROM database" and when I return the information I'm loading it into a collection object.

Dim DataHold As New Collection
Dim xConnection As New ADODB.Connection
Dim xRecord As New ADODB.Recordset

DataHold.Add (xRecord.Fields(5))

after that I check the DataHold.item(1) and it returns 12/02/2001
but it should be 12/02/2001 10:23:32 AM
I can't figure out how to not cut it after the space

I have also set it to a string then loaded the string into the collection...but it still cuts after the space

thanks for any help

 

[gigsvoo]

Use this when:

Format("20-12-2001", "dd-mm-yyyy hh:mm:ss&quot Thanks

Neo

http://communities.msn.com.my/VisualBasicwithNeo