check for added contact tel

[Number11]

so i am looking for a way to check if the user has added the tel to a template they can select as ending

xxxxxx -Contact Tel- if nothing added after this say a message?

 

[Gasman]

Que?

 

[jdraw]

A little context or sample data needed!

 

[Number11]

so the form has a combo field that users can select 5 differnt templates all they need to do is add after -Contact Tel the customers details i want some to prompt if nothing has been added ?

 

[Gasman]

Why make the users do it.?
Do it yourself with VBA and concatenation?

 

[Pat Hartman]

Clearly, we're having trouble visualizing what you are trying to do. In post #5 (not #1) you finally mentioned that you were talking about text selected from a combo. SO, the answer, as with all validation, is to put your validation in the FORM's BeforeUpdate event. That allows you to cancel the save and return control to the user so he can enter the desired phone number.

If Me.SomeCombo = " blah blah blah" Then
    If Me.SomeField & "" = "" Then  'field is empty
        Msgbox "Please enter Telephone number.", vbOKOnly
        Me.SomeField.SetFocus
        Cancel = True
        Exit Sub
    End If
End If

Not sure if you want to try to determine if the text entered matches the pattern for a phone number but you could do that also.

 

[Gasman]

Would also need to ensure the phone number is valid, I would have thought? How are you going to do that?