Database duplicates and case sensitivity

[K-Pax]

I use<BR>Try <BR>objCmd.ExecuteNonQuery() <BR>Catch Exp As OleDbException <BR>lblCompanyError.Text = "An error occured"<BR>End Try<BR><BR>To catch any errors that may occur. I have NO DUPLICATES enabled in my MS Access database. Now, when I enter a field with the exact case as displayed in my db, it gives me an error, Try catches it and says to the user it has an error inserting the new record. I also check if the text field is empty and respond with an error message too.<BR><BR>BUT<BR><BR>Example, MyDataBaseEntry is in the database, it will catch the error when I try entering MyDataBaseEntry, but it won't catch the error when I try entering mydatabaseentry, and gives me an ugly error message.<BR><BR>Now I have this data bound to a dropdownlist already (which I just hide if the person wants to add a company and then re-bind the data when successful, displaying the dropdown again)<BR><BR>Is there a way I could make it that it's NOT case sensitive, but still error trap when it has duplicates? I tried using LCASE and UCASE, but it then gives me other errors.<BR><BR>Anyone with the same problem? Or anyone know what this could be? HELPI have done some serious debugging and found that there is nothing wrong with the database insert, in fact, it couldn't work any better.<BR><BR>The problem I experience is with the dropdown list. I use FindByText and use the text field I just used to insert the new "company" to select the entry automatically after re-binding the data.<BR><BR>Unfortunatly this gives me the Null error I was talking about in this post, because FindByText is case sensitive.<BR><BR>Are there anyone out there that has an alternate way of getting the dropdownlist to automatically select the record just added??<BR><BR>Thanks in advance