I am connecting to a Access XP MDB file using VB6 via ADO 2.5.

I am in need of getting the Field (format/layout) of the fields in a RecordSet and cannot find any information on this topic.

Field Name 'DOB'
Format 'dd mmm yyyy'

Field Name 'LastName'
Format '>'

I want to be able to get that format string into a variable in VB.

Any help would be appritiated.