Solved Form - Best way to prompt users that they must complete a form field

[Number11]

Love to hear about the best way to prompt the user when they leave a field black

Message - Please Complete Customers Telephone Number! - This cant be leave blank!

 

[jdraw]

Is it possible to have a Customer who does not have a phone? Perhaps this is not a realistic criteria.
You can check for a value in the BeforeUpdate event. You can set the control's Tag property to "Required", and issue a message as appropriate.
BUT it seems reasonable that a Customer may not have a phone.

 

[Number11]

Is it possible to have a Customer who does not have a phone? Perhaps this is not a realistic criteria.
You can check for a value in the BeforeUpdate event. You can set the control's Tag property to "Required", and issue a message as appropriate.
BUT it seems reasonable that a Customer may not have a phone.

Thanks no we always have a telephone number so how would i get this setup

 

[Number11]

sorted it using this...

Dim strSQL As String
Dim ctl As Variant

If IsNull(Me.TelephoneNo) Then

Dialog.Box "Please enter a Customer Telephone Number!", vbCritical, "Data entry error..."
Me.TelephoneNo.BorderColor = vbRed
Me.TelephoneNo.SetFocus
Exit Sub
Else

 

[jdraw]

Is TelephoneNo dimmed as numeric??