Setting a date/time field to 'NULL'

G

Guest

I have several date/time fields on a custom form (all tied to user-defined
fields). I would like the field to display nothing when a new item is
created. Currently, the default values for the TEXT and VALUE properties when
I added the fields was 'NONE' which displays when a new item is created. If I
delete the value or change it to a non-date/time (eg a zero-length string or
''), I get an error message indicating that a date/time must be selected.

What value should I enter in the TEXT/VALUE properties so that nothing is
displayed in the fields when a new item is created using the form?
 
S

Sue Mosher [MVP-Outlook]

#1/1/4501# is the date that Outlook stores when the user sees "None." Displaying nothing at all is not an option.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date field in custom form 1
click date/time field display calendar and validation of date /tim 0
Reminder (Off / On) Link With Reminder Data/Time 3
Forms - unknown field requires a value 6
date/time field, current year 2
DTPicker Default Date 0
Setting Date and Time 2
Access Access - Is it possible to repeat fields in a form? 1

Top