IF AND Validation Formulas in Custom Form

Status
Not open for further replies.
M

maxwello

Member
Outlook version
Email Account
Exchange Server
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
 
Thanks Larry,

Although I still cannot get it to work, will the statement work in the Validation Formula bar?

=IIf([Platform]="Bloomberg",[Clearing Applicable] <> "")
 
Anything available in Fields and Functions should work.

Do you get any error messages?

The formula format is IIf( expr , truepart , falsepart ) and it looks like you are missing the falsepart. (I'm not sure the true part is right either)
 
Diane Poremsky said:
Anything available in Fields and Functions should work.

Do you get any error messages?

The formula format is IIf( expr , truepart , falsepart ) and it looks like you are missing the falsepart. (I'm not sure the true part is right either)
Click to expand...

Hi Diane,

What I want to happen is If Bloomberg = yes then the user needs to put a value in client clearing field, if they dont I need the error message to pop up asking the user to add a value and if Bloomberg isnt selected at all then to ignore everything and carry on.

So far I have entered the formula in the properties validation line and then entered the message in the line below. But with the formulas that I have played around with so far I cannot get anything to work. I would really appreciate some further assisance as this is stopping me getting any further on my project.

Kind Regards

OLiver
 
Status
Not open for further replies.
< Outlook 2010 IMAP account message move behavior | Outlook reply to Gmail prints gobbledygook >
Similar threads
Thread starter Title Forum Replies Date
F Validation on custom task form after task acceptance Outlook VBA and Custom Forms 1
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
B Date validation in Outlook Custom Form Using Outlook 2
C Forms: Validation Using Outlook 0
C Outlook Forms: Validation Using Outlook 7
S Reminder Time and Reminder Validation Outlook VBA and Custom Forms 2
F Data validation Outlook VBA and Custom Forms 4
C Adding date Validation between 2 months Outlook VBA and Custom Forms 3
C date formulas / mathematics, setting a field one hour past another field value Outlook VBA and Custom Forms 1
G Apply Custom Contacts form to all existing Contacts Outlook VBA and Custom Forms 1
G Add Map It button to Custom Contacts Form in Outlook Outlook VBA and Custom Forms 1
G Outlook 2021 Add Picture to Custom Contact Form Outlook VBA and Custom Forms 2
X Custom icon (not from Office 365) for a macro in Outlook Outlook VBA and Custom Forms 1
P Can't add custom field to custom Outlook form, it always adds to the Folder instead Outlook VBA and Custom Forms 2
AndyZ Contact Custom Form Tiny Text Outlook VBA and Custom Forms 3
A How to reduce size of custom contact form? Outlook VBA and Custom Forms 3
S Custom Contact card - need help creating one Outlook VBA and Custom Forms 1
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
S Adding Custom Forms Outlook VBA and Custom Forms 4
Witzker How to get the button Karte ( map) in custom contact form Outlook VBA and Custom Forms 2
B Outlook 2019 Custom Email form - Edit default email form Outlook VBA and Custom Forms 6
D Outlook 365 Custom forms field limit? Outlook VBA and Custom Forms 4
J PSA: How to create custom keyboard shortcut for "Paste Unformatted Text" in Outlook on Windows Outlook VBA and Custom Forms 1
M copy field value to custom field Outlook VBA and Custom Forms 0
J Does the .fdm contain my custom form? How to make ol use it? - ol2007 Outlook VBA and Custom Forms 4
J ol2021 custom form not displaying pics Outlook VBA and Custom Forms 37
N "Perform a Custom Action" Outlook VBA and Custom Forms 0
cbufacchi Outlook 365 Populate custom Outlook Appoint form Outlook VBA and Custom Forms 2
C Create Meeting With Custom Form Outlook VBA and Custom Forms 2
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
J custom form not displaying pictures Outlook VBA and Custom Forms 7
I Button PDF in Outlook Contact custom form Outlook VBA and Custom Forms 1
K Font Sizing in Custom Form Regions for Contacts Outlook VBA and Custom Forms 1
V Update new custom field Outlook VBA and Custom Forms 5
D Anyone tell me where custom view settings are stored? Outlook VBA and Custom Forms 9
S Outlook 2016 Arrange tasks by date, additional custom sorting, but still use friendly terms like Today, Tomorrow, This week? Using Outlook 1
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
H Custom Outlook Contact Form VBA Outlook VBA and Custom Forms 1
S Custom Field Cannot Be Displayed In Views Outlook VBA and Custom Forms 2
D Custom Search Folders not refreshing/updating automatically Using Outlook 0
K UDF with formula not showing on Calendar custom view. Outlook VBA and Custom Forms 0
S Create a clickable custom column field Outlook VBA and Custom Forms 0
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
M VbScript for Command Button on Contacts Custom Form Using Outlook 1
G Other users can't see P.2 with custom fields in Form Outlook VBA and Custom Forms 0
O Create a custom contact form - questions before messing things up... Outlook VBA and Custom Forms 4
S Reference Custom Fields with VBA Outlook VBA and Custom Forms 2
L Custom Form Tutoral? Outlook VBA and Custom Forms 6
D Lost Access to Custom Form Outlook VBA and Custom Forms 4
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1

Similar threads

Back
Top