determinig field types

[Nath]

Hi i have created a recordset in ADO, and would like to
determine the field type of each field i.e. field1 = text,
field2 = memo, and so on, can anyone advise on how to do
this please. I have tried rst.fields(1).type, but this
just gives a number, if this is correct, where do i find
out what these numbers mean.

TIA

Nath

 

[Naresh Nichani MVP]

Hi:

Take a look at --
http://www.w3schools.com/ado/ado_datatypes.asp

Regards,

Naresh Nichani
Microsoft Access MVP