Hi

I bound data from a database using the format:

    Dim strSQL2 as string = "select * from org order by orgname"

    Dim objCommand2 as New OdbcCommand(strSQL2, myConnection2)
    Dim objDataReader2 as OdbcDataReader

        myConnection2.Open()

    objDataReader2 = objCommand2.ExecuteReader(CommandBehavior.CloseCon nection)

        DropDownList5.DataSource = objDataReader2
        DropDownList5.DataTextField = "orgname"
    DropDownList5.DataValueField = "orgname"

        DropDownList5.DataBind()

This works fine if I select < 30 record but anything above and the page OnClick event I have stops working.

Basically I have a form and the dropdownlist provides a list of companies held in a MS Access database. There about 800 companies but I cannot get the DropDownList to handle >= 30 items . Is there a configurable limit? Is there an alternative method to cope with larger results set?

Thanks