Making a Date field mandatory in outlook form

Status
Not open for further replies.
V

vincetaylor

Senior Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
I am trying to do something very basic which is to make a date field mandatory in an outlook form. For some reason, I don't know , the checkbox to make a field mandatory is always grayed out for date fields.

Does anyone know why this checkbox is always greyed out?

Since the checkbox is always grayed out, I have tried several formulas:

1. [DueDate] <> "" : This does not work at all. It allows a user to send a form whether the date field is filled or not
2. [DueDate] = "" : This one causes the validation message to be displayed whether a person enters a date or not
3. \[DueDate\] "" : This one also causes the validation message to be displayed whether a person enters a date or not
Also for some reason, Outlook automatically adds quotation marks to the formula so it becomes "\[DueDate\] """


Does anyone have any thoughts on how to validate a date field to prevent users from leaving it blank?

2825
 
They fail because the default value is None - DueDate] <> "" will always validate - that may be why its greyed out too. Use IsDate( [DueDate] ) to validate.

You can also use [DueDate] <> "None"
 
Status
Not open for further replies.
< Nested email attachments | Too many scripts? >
Similar threads
Thread starter Title Forum Replies Date
C Why does Outlook (desktop) 365 for Windows keep making me input my passwords? Using Outlook 12
A Outlook 2019 having issues with 'people search' and not making suggestions in email To: etc Using Outlook 12
P Making iCloud the default calendar for Outlook 2016 Using Outlook 3
CWM030 Thinking about making the plunge. Exchange Server Administration 6
M Making Subject field writable (disable Read Only) Outlook VBA and Custom Forms 2
L Making rule to move email to folder from one O365 domain Using Outlook 1
Michael R Belleville Making an Attachment Name the Message Subject Using Outlook 2
Pierce007 Maps/location in making an appointment Using Outlook 2
R Making Outlook default client in share charm Using Outlook 4
D No Follow up when making new form Outlook VBA and Custom Forms 2
C Safeguards against accidental deletion / making inactive. BCM (Business Contact Manager) 1
Z Making Outlook Default folders to local/personal instead of Hotmail Using Outlook 8
T Need help making RULE to prepend email SUBJECT Using Outlook 3
T Outlook 2003 - Making a distribution list from a contact folder Outlook VBA and Custom Forms 1
J Making custom Outlook 2007 folders emptiable like "Deleted Items" Outlook VBA and Custom Forms 1
J Making field editable in custom form Outlook VBA and Custom Forms 2
H Macro to Delete Duplicate items in Outlook calendar where title is the same and date is the same Outlook VBA and Custom Forms 0
F Outlook 365 Group INBOX by date but not by date and time Using Outlook 1
S Displaying Date Value In Formula Outlook VBA and Custom Forms 6
CWM330 Wrong Date Using Outlook 4
C Outlook 365 Copy/Save Emails in Folder Outside Outlook to Show Date Sender Recipient Subject in Header Using Outlook 0
R unable to filter tasks when start date is on or before today Using Outlook 4
S Combination Field (Date Format) Outlook VBA and Custom Forms 0
U How can the Received date be edited? Using Outlook 0
D This folder up to date vs all folders up to date Using Outlook 1
S Outlook Macro for [Date][Subject] Using Outlook 1
N Save emails within a certain date range to network drive Outlook VBA and Custom Forms 0
kburrows Reset Date to Keep Tasks from Archiving Using Outlook 9
M Extract "Date sent" from emails (saved to folder using drag and drop) Outlook VBA and Custom Forms 1
DDB VBA to Auto Insert Date and Time in the signature Outlook VBA and Custom Forms 2
P Short Date Format when typing in a task Using Outlook 2
S Change "This Week" flag start date behavior Using Outlook 1
S Archiving and Likely Modified Date Problem Using Outlook 3
A VBA Script - Print Date between first email in Category X and last email in Category Y Outlook VBA and Custom Forms 3
S Outlook 2016 Arrange tasks by date, additional custom sorting, but still use friendly terms like Today, Tomorrow, This week? Using Outlook 1
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 17
S save attachment with date & time mentioned inside the file Outlook VBA and Custom Forms 0
Witzker Pls help to change the code for inserting date in Ol contact body Outlook VBA and Custom Forms 5
C Outlook with Office365 - search across account, by date rate, in multiple folders - how? Using Outlook 2
M Sorting by Day in Date Column Advanced Filter BCM (Business Contact Manager) 1
V Date and/or time error in Outlook Form Outlook VBA and Custom Forms 0
S Body text of Email from invite date/time Outlook VBA and Custom Forms 7
V 10 Years calenders -single date together Exchange Server Administration 8
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
D Add date next to day name in Outlook Today calendar view Using Outlook 1
X If you change expiration date of repeated task it dupplicates Using Outlook 1
D Archive by receive date not working Using Outlook 2
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
L Ctrl Alt d date stamp use Using Outlook 1
A Create date folder and move messages daily Outlook VBA and Custom Forms 1

Similar threads

Back
Top