Checking for empty field

vincetaylor

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
HI all. I would appreciate any help with this issue.


I have a dropdown field called [transfer]. It is a text field and has drop down options.
I need to check if the field is left blank. If left blank, it should pop up a custom error message such as "Invalid Entry"
If the field is populated with one of the drop down options then the form can be sent.

I have tried the following methods.
  1. [transfer] =""
  2. [transfer] =" "
  3. Len([transfer] )=0
  4. Len([transfer] )<1
Result: Form is sent even when transfer field is not populated
  1. I have also tried the following methods
  2. IsEmpty([transfer ])
  3. Len("transfer" )<1
  4. "\[transfer\] """
  5. IIf( [transfer]="","Invalid Entry","")

    Result: The error is displayed whether the field is populated or left blank. Basically I cannot send the form as the error message blocks it.
Ordinarily I would check for empty fields by checking the checkbox: "A value is required for this field"
But I can't do so here because a custom error message is required and also this formula will be used as part of a compound formula.
transfer is blank.JPG
iif.jpg
 
Similar threads
Thread starter Title Forum Replies Date
S Problem Checking the available stores in my Inbox (Outlook VBA) Outlook VBA and Custom Forms 0
M Account sequence when checking mail Using Outlook 6
T Checking mailbox emails Outlook VBA and Custom Forms 0
B Auto name checking upon Tab or Click off To field(s) Using Outlook 19
S Checking attachment is passward protected or not before sending the mail Using Outlook 1
S Outlook Macro for checking the mail is sent to outside organization Using Outlook 3
J Checking PST File Keeps Crashing Using Outlook 2
L Script to: Change subject of email after checking body Using Outlook 2
H Redirection checking Exchange Server Administration 10
S Stop mail checking Using Outlook 5
B Too many ' tasks' when checking email Using Outlook 1
B Checking attachments as they arrive Outlook VBA and Custom Forms 1
Paul Hobbs Automatically accept "Empty Folders" prompt Outlook VBA and Custom Forms 6
vodkasoda Hiding empty Folders Outlook VBA and Custom Forms 0
I Outlook 2003 shows html code when To: field is empty Using Outlook 7
S Conditional formatting problem with "is not empty" and categories Using Outlook 2
Daniel Schunk User-defined form arrives empty at the recipient Using Outlook 3
semnaitik Archive PST is not empty but can't see old emails Using Outlook 2
M Multiple spurious empty folders appear in archive files Using Outlook 3
S Empty an Office365 public folder containing 20.000 messages Using Outlook 2
B Choose commands from Macros is empty Outlook VBA and Custom Forms 3
I Many empty Contacts folders.. cannot get rid of them Using Outlook 4
wisedave IMAP Mail Directory Keeps Going Empty Using Outlook 5
A Mysterious random appearance of empty unsent email Using Outlook 3
A Prompt on exit to empty deleted items folder "for all accounts" does not work? Using Outlook 6
M empty fields after Contact History personalisation BCM (Business Contact Manager) 0
S 2010 outlook today looks like an empty email box Using Outlook 4
A email folders appear empty, at first click Using Outlook 2
H Calendar Folder property is empty Using Outlook 1
M Contact Manager field is empty BCM (Business Contact Manager) 0
S Please help! -- Linked Account field at Business Contacts tab is always empty BCM (Business Contact Manager) 1
B In Box Empty Using Outlook 5
P Imap Folders are present, but the inbox folder is empty except for new message Using Outlook 3
V What is wrong with Outlook Connector - it still errors out on an EMPTY Hotmail Using Outlook.com accounts in Outlook 3
M How to clean duplicate/empty e-mail address fields in Outlook contacts Using Outlook 0
R Why Internet headers empty? Exchange Server Administration 2
M Empty Deleted items folder - Other users folder Outlook VBA and Custom Forms 1
M Received date empty Outlook VBA and Custom Forms 5
T Outlook Forms Not Working - Fields Empty Outlook VBA and Custom Forms 7
S CONTACT FIELD PRINT ORDER Outlook VBA and Custom Forms 1
V Update new custom field Outlook VBA and Custom Forms 5
HappyDaddy007 "Size" on field chooser/column displaying incorrect value Using Outlook 3
A Is there an ID field you can use to pair a reply to the sent email? Outlook VBA and Custom Forms 4
H Information from user defined field into Excel Outlook VBA and Custom Forms 7
Terry Sullivan Sender's Name Doesn't Appear in the From Field on Outlook 365/IMAP Using Outlook 2
D Outlook Contacts Notes Field Photos to Smartphone Using Outlook 0
S Custom Field Cannot Be Displayed In Views Outlook VBA and Custom Forms 2
Terry Sullivan Sender Field Displays My E-Mail Address, Not My Name Using Outlook 1
S Create a clickable custom column field Outlook VBA and Custom Forms 0
B User defined field for messages with 'me' in the [To], [Cc] line Using Outlook 0

Similar threads

Top