Hi,
I am a Newbie to Outlook Custom Forms and I want to know if it is possible to use a IF AND formula in the validation tab under properties.
What I want to happen is, If the user has selected Bloomberg in the platform field and the Clearing Applicable field is Blank then to throw up a message "Please advise if Clearing is applicable"
I have tried, IF [Platform]="Bloomberg" AND [Clearing Applicable] <> "" and different variations and I have broken it down and tried just using [Clearing Applicable] <> "" which gives me the message but when I tried [Platform]="Bloomberg" nothing worked.
I have searched the internet but haven’t had any luck finding a solution PLEASE HELP.
Appreciative Newbie
I am a Newbie to Outlook Custom Forms and I want to know if it is possible to use a IF AND formula in the validation tab under properties.
What I want to happen is, If the user has selected Bloomberg in the platform field and the Clearing Applicable field is Blank then to throw up a message "Please advise if Clearing is applicable"
I have tried, IF [Platform]="Bloomberg" AND [Clearing Applicable] <> "" and different variations and I have broken it down and tried just using [Clearing Applicable] <> "" which gives me the message but when I tried [Platform]="Bloomberg" nothing worked.
I have searched the internet but haven’t had any luck finding a solution PLEASE HELP.
Appreciative Newbie