Checking for empty field

Status
Not open for further replies.

vincetaylor

Senior 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
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
L Checking Sender Email Address for trusted domain from list on intranet Outlook VBA and Custom Forms 4
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
P Can't add custom field to custom Outlook form, it always adds to the Folder instead Outlook VBA and Custom Forms 2
H Copying email address(es) in body of email and pasting in To field Outlook VBA and Custom Forms 1
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 3
D Outlook 365 Custom forms field limit? Outlook VBA and Custom Forms 4
Witzker Set Cursor & Focus from any field to the body of a user Contact form in OL 2019 Outlook VBA and Custom Forms 1
S Combination Field (Date Format) Outlook VBA and Custom Forms 0
Witzker Add a text line at the end of the note field in all selected Contacts Outlook VBA and Custom Forms 7
M copy field value to custom field Outlook VBA and Custom Forms 0
J images on note field display fraction of size Using Outlook 5
C Automatically Insert Recipient Name from To Field Outlook VBA and Custom Forms 4

Similar threads

Back
Top