When I try to get the fieldtypenumber from the fields I get the same 

number (203) from a Link type and a Note type. I hope somebody knows how 

to get an ID that is not the same or how to get the fieldtypename. I 

currently use .type to get the ID. I would really appreciate som feedback 

on this. Thanks.

> When I try to get the fieldtypenumber from the fields I get the same 

> number (203) from a Link type and a Note type. I hope somebody knows how 

> to get an ID that is not the same or how to get the fieldtypename. I 

> currently use .type to get the ID. I would really appreciate som 

feedback 

> on this. Thanks.

I am not sure what a link type is vs a note type.  If you are using Access 

then I assume you are referring to hyperlink and memo.  The default data 

provider driver for Access has to identify the hyperlink type as one of 

the standard ADO data types, so it uses the adLongVarWChar type as it does 

with memo fields.  This data type is the one that supports the 2048 

character length of the hyperlink string.



You can find a list of data types used with ADO at:



http://msdn.microsoft.com/library/default.asp?url=/library/en-

us/ado270/htm/mdcstdatatypeenum.asp



The data provider that you use will determine how the field types in the 

database fit into these categories.  If I assumed right about the 

hyperlink and memo fields then you will not be able to use the type 

property to determine the difference in the fields.  You will probably 

need to run some determination on the value of the field in order to tell 

the difference between the two types.





> When I try to get the fieldtypenumber from the fields I get the same 

> number (203) from a Link type and a Note type. I hope somebody knows how 

> to get an ID that is not the same or how to get the fieldtypename. I 

> currently use .type to get the ID. I would really appreciate som 

feedback 

> on this. Thanks.