Return Field Data Type

[vanillapod]

Hi I've got a page that lists all field names contained within an Access Database table, can anyone tell me how I find the data type of each field as well?

Cheers

 

[Sheco]

Please post your code.

Otherwise we have to assume that you are using FOR EACH on the ADO .Fields collection.... if so you seek the .Type property it will return a number that represents an ADO DataTypeEnum.

 

[vanillapod]

Hey Sheco thanks for the reply my code is:

for each f in lg.Fields
If f.name<>"ID" Then
Response.Write("<option value=" & f.Name & ">" & f.name & "</option>")
End If
next

 

[vanillapod]

just used .type and it works a treat! realy easy as well, thanks a lot