Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 104
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Failed to save table attributes of (null) into (null). Luca Brasi Excel Discussion (Misc queries) 2 February 4th 09 04:30 PM
setting a cell to 'empty' or blank or null ? KRK New Users to Excel 7 May 7th 08 12:49 AM
DTPicker Bug Steve23 Excel Programming 0 June 26th 07 11:36 AM
DTpicker kj135 Excel Programming 2 June 1st 07 06:26 PM
DTPicker Syed Haider Ali[_37_] Excel Programming 0 July 11th 06 08:38 PM


All times are GMT +1. The time now is 02:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"