ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Setting DTPicker to a null value (https://www.excelbanter.com/excel-programming/406840-setting-dtpicker-null-value.html)

vqthomf

Setting DTPicker to a null value
 
Hi I am using a DTPicker ctrl on a form and I am trying to set it to a null
value at form startup, I have used the code blow and this works but when the
user selects a date it wont show in the DTP box. Has anybody managed to solve
this problem?.
Regards Charles

With DTPicker1
.CustomFormat = " "
.Format = dtpCustom
End With


Jim Thomlinson

Setting DTPicker to a null value
 
Check out this link...

http://www.microsoft.com/communities...xp=&sloc=en-us
--
HTH...

Jim Thomlinson


"vqthomf" wrote:

Hi I am using a DTPicker ctrl on a form and I am trying to set it to a null
value at form startup, I have used the code blow and this works but when the
user selects a date it wont show in the DTP box. Has anybody managed to solve
this problem?.
Regards Charles

With DTPicker1
.CustomFormat = " "
.Format = dtpCustom
End With



All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com