Getting the database column type

Hi.
I'm trying to get the database column type. I looked up for it in google but it showed no results.
What I'm trying to do is just to check the character limit of the field - ie: varchar(50) would be 50 characters limit.

I have access to the fields and it all works fine. But what I'm creating is a dynamic way to add fields to the database so the use won't have to open the database using access all the time and just edit it through the site.

Is there a way to achieve that?

Thanks.

I believe you want Recordset.Field("columnname").DefinedSize

http://www.devguru.com/Technologies/ado/QuickRef/field.html

Thanks!