| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set date time picker to null (blank)
Hello,
I have a form with a date time picker. I'm using Excel 2007. When the form opens, my boss wants the date time picker to be blank. I'm not sure if that is possible and had previously set it to current date. I've tried setting it to vbNULL. This sets the value at 12/31/1899. So I thought I would at least ask the group, can you make the date time picker blank when first opening a form? During data entry, the data entry person will set the date as appropriate. Thanks. Tony |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set date time picker to null (blank)
check out this link...
http://www.microsoft.com/communities...xp=&sloc=en-us -- HTH... Jim Thomlinson "Webtechie" wrote: Hello, I have a form with a date time picker. I'm using Excel 2007. When the form opens, my boss wants the date time picker to be blank. I'm not sure if that is possible and had previously set it to current date. I've tried setting it to vbNULL. This sets the value at 12/31/1899. So I thought I would at least ask the group, can you make the date time picker blank when first opening a form? During data entry, the data entry person will set the date as appropriate. Thanks. Tony |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set date time picker to null (blank)
Sorry this link is to the correct question...
http://www.microsoft.com/communities...f-ab03d18fbe82 -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: check out this link... http://www.microsoft.com/communities...xp=&sloc=en-us -- HTH... Jim Thomlinson "Webtechie" wrote: Hello, I have a form with a date time picker. I'm using Excel 2007. When the form opens, my boss wants the date time picker to be blank. I'm not sure if that is possible and had previously set it to current date. I've tried setting it to vbNULL. This sets the value at 12/31/1899. So I thought I would at least ask the group, can you make the date time picker blank when first opening a form? During data entry, the data entry person will set the date as appropriate. Thanks. Tony |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set date time picker to null (blank)
you tried
DTPicker1.Value = "" "Webtechie" wrote: Hello, I have a form with a date time picker. I'm using Excel 2007. When the form opens, my boss wants the date time picker to be blank. I'm not sure if that is possible and had previously set it to current date. I've tried setting it to vbNULL. This sets the value at 12/31/1899. So I thought I would at least ask the group, can you make the date time picker blank when first opening a form? During data entry, the data entry person will set the date as appropriate. Thanks. Tony |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set date time picker to null (blank)
You will get an error message if you set it to "".
"Patrick Molloy" wrote: you tried DTPicker1.Value = "" "Webtechie" wrote: Hello, I have a form with a date time picker. I'm using Excel 2007. When the form opens, my boss wants the date time picker to be blank. I'm not sure if that is possible and had previously set it to current date. I've tried setting it to vbNULL. This sets the value at 12/31/1899. So I thought I would at least ask the group, can you make the date time picker blank when first opening a form? During data entry, the data entry person will set the date as appropriate. Thanks. Tony |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set date time picker to null (blank)
That is the link I used to set it to vbNull. However, setting it to vbNull
sets the date time picker to 12/31/1899. It is not null or blank. "Jim Thomlinson" wrote: Sorry this link is to the correct question... http://www.microsoft.com/communities...f-ab03d18fbe82 -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: check out this link... http://www.microsoft.com/communities...xp=&sloc=en-us -- HTH... Jim Thomlinson "Webtechie" wrote: Hello, I have a form with a date time picker. I'm using Excel 2007. When the form opens, my boss wants the date time picker to be blank. I'm not sure if that is possible and had previously set it to current date. I've tried setting it to vbNULL. This sets the value at 12/31/1899. So I thought I would at least ask the group, can you make the date time picker blank when first opening a form? During data entry, the data entry person will set the date as appropriate. Thanks. Tony |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Time Picker | Excel Discussion (Misc queries) | |||
| Date and Time Picker | Excel Discussion (Misc queries) | |||
| Date/Time Picker | Excel Programming | |||
| date time picker | Excel Programming | |||
| Set Value for Date/Time Picker | Excel Programming | |||
Linear Mode
