how to Validate fields(textbox and combobox) on form before submitting data into access database using vb6.0.

Question

I use vb 6.0 to design my form.In my form i have 10 fields which include student related details like rollno,date of birth,dept etc....now i have to validate each fields before save the record into the database.

thanks in advance.........

Satyapriya Nayak · Answer

Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object ByVal e As System.EventArgs) Handles Button1.Click For Each cnt As Control In Me.Controls If TypeOf cnt Is TextBox Then If cnt.Text =  Then MessageBox.Show(TextBox is Blank.) cnt.BackColor = Color.Pink End If ElseIf TypeOf cnt Is ComboBox Then Dim cmb As ComboBox = DirectCast(cnt ComboBox) If cmb.SelectedItem Is Nothing Then MessageBox.Show(Combox is not Selected.) cnt.BackColor = Color.Plum End If End If Next End Sub Private Sub Form1_Load(ByVal sender As System.Object ByVal e As System.EventArgs) Handles MyBase.Load ComboBox1.Items.Add(a) ComboBox1.Items.Add(b) End Sub End Class