Many of my Searchfields are integers and for a lot of them I can't use a dropdown to make sure an integer is the entered result.

Since the searchfield is a textbox, the user can enter an alpha string and then get an ugly error on the search

How do I make sure only integers can be entered into the searchfield ?

I tried this :

        private void bdExchanges_InitializeSearchFields(object sender, EventArgs e)            {            bdExchanges.SearchFields["From_Date"].InitialValue = DateTime.Today.ToString();            bdExchanges.SearchFields["Thru_Date"].InitialValue = DateTime.Today.ToString();            // this searchfield has override data type set to Int32 in BD Searchfields properties UI            bdExchanges.SearchFields["ReutersExchangeID"].FieldType.Equals(SqlDbType.Int);                        }

but that does not seem to be the answer?

Eddy, you can be my hero again ( and this time I'll pay attention )