Question on validation

[Idontknowanything]

Hi, sorry i have a question on validation. I think it must be too simple for you guys. Please pardon me.

I have a command button to update information entered by customer to the database. Everything is fine but i want to add a message to show e.g "Please enter your address" if the customer has left the address textbox empty.

I will have to add the validation into the Private Sub btnUpdateInfo_Click() - (the name for my insert button) right?

I entered this code but it doesn't work
If (txtAddress.value = "") Then
MsgBox "Enter your address"
End If

I tried using <IsNull(txtAddress.value)> and <txtAddress.value Is Null> but they don't work as well.

Can anyone help me solve this?

And can how can i apply to the rest of the textboxes as well?

Sorry for the trouble and thank you so much fo your effort and time.

Sincerely,
Idontknowanything

[ADezii]

Hi, sorry i have a question on validation. I think it must be too simple for you guys. Please pardon me.

I have a command button to update information entered by customer to the database. Everything is fine but i want to add a message to show e.g "Please enter your address" if the customer has left the address textbox empty.

I will have to add the validation into the Private Sub btnUpdateInfo_Click() - (the name for my insert button) right?

I entered this code but it doesn't work
If (txtAddress.value = "") Then
MsgBox "Enter your address"
End If

I tried using <IsNull(txtAddress.value)> and <txtAddress.value Is Null> but they don't work as well.

Can anyone help me solve this?

And can how can i apply to the rest of the textboxes as well?

Sorry for the trouble and thank you so much fo your effort and time.

Sincerely,
Idontknowanything

If IsNull(Me![txtAddress]) Then
   'code here
End If

[NeoPa]

Firstly, an empty control will return a Null value rather than an empty string ("").
That said, it is not usual to need a Command Button to save a record on an Access form. Simply moving from one record to another on a bound form will trigger the update. Handling that would be done in the form's BeforeUpdate event procedure.

Private Sub Form_BeforeUpdate(Cancel As Integer)
    If IsNull(Me!txtAddress) Then
        Call MsgBox("No address entered")
        Cancel = True
    End If
End Sub