How to use Access Columns Types in .NET

[saurabhpunn]

Hi All,

I need to know if there is way to figure out if a particular Column in an Access Table is of type "ComboBox" or "TextBox". For Example:

In Access I'm having a table "XYZ". This has 2 Columns "X" and "Y". In Access, I've assigned the "Display Control" tag (Open any Access Table->Go o to "Design View"-> Go to "Lookup" tab) as "Combobox" for Column "X" and as "TextBox" for Column "Y".

Is there a way that I can query this property in my C# code? i.e.

dc = DataTable.Columns[0];
if (dc.<To Figure Out>.ComboBox)
{


//Do Something
}

Thanks

[June7]

Maybe this will help http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
And this helped me write VBA procedure below to list property info http://www.java2s.com/Code/VBA-Excel...mTableDefs.htm

Sub ListProperties()
    Dim db
    Dim fld As Field 
    Set db = CurrentDb
    For Each fld In db.TableDefs![your table name].Fields
        If fld.Name = "your field name" Then
            Debug.Print "Name: " & fld.Name
            Debug.Print "DisplayControl: " & fld.Properties("DisplayControl").Value
        End If
    Next
    db.Close
End Sub

I get these results for Value:
Textbox - 109
Listbox - 110
Combobox - 111

Some field datatypes don't have DisplayControl property and the code will error if that datatype encountered, Memo and Attachment are two I know of.

If you want to know C# code, probably need to post in C# forum.