View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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