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

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

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

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

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

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