N Number11 Member Local time Today, 09:05 Joined Jan 29, 2020 Messages 625 Jan 18, 2022 #1 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?
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 Enthusiastic Amateur Local time Today, 09:05 Joined Sep 21, 2011 Messages 17,483 Jan 18, 2022 #2 Que?
jdraw Super Moderator Staff member Local time Today, 04:05 Joined Jan 23, 2006 Messages 15,574 Jan 18, 2022 #3 A little context or sample data needed!
N Number11 Member Local time Today, 09:05 Joined Jan 29, 2020 Messages 625 Jan 18, 2022 #4 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 ?
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 Enthusiastic Amateur Local time Today, 09:05 Joined Sep 21, 2011 Messages 17,483 Jan 18, 2022 #5 Why make the users do it.? Do it yourself with VBA and concatenation?
Gasman Enthusiastic Amateur Local time Today, 09:05 Joined Sep 21, 2011 Messages 17,483 Jan 18, 2022 #6 Would also need to ensure the phone number is valid, I would have thought? How are you going to do that?
Would also need to ensure the phone number is valid, I would have thought? How are you going to do that?