Differentiate between Varchar and Text

Does anyone know of a way to differentiate between a VarChar column and a Text column?  The only way to determine column type seems to be comparing [columnObject].SystemType with TypeOf(System.[TypeName]), like this...

if (column.SystemType == TypeOf(System.String))
{
    // Do something here
}

This finds ALL string types, and does not differentiate between the various types.

If I am referencing a Text column, it would be nice to know that so I can generate the appropriate TextBox type, preferably multi-line with no limit.

Please help!

Thanks,

Eric.

Hi,

You can use the ColumnSchema.NativeType property.  That will have varchar or text for the sql server type.

~ Paul