Codejock Developer Community : [SOLVED] DateTimePicker Display Bug!?

[SOLVED] DateTimePicker Display Bug!? : Hemesh, Thanks for that, this...

Mon, 30 Aug 2010 03:24:50 +0000

Author: Xander75
Subject: 17154
Posted: 30 August 2010 at 3:24am

Hemesh,

Thanks for that, this has resolved the issue I was having.

[SOLVED] DateTimePicker Display Bug!? : maybe try dd/MM/yyyy instead of...

Fri, 27 Aug 2010 11:19:46 +0000

Author: Hemesh
Subject: 17154
Posted: 27 August 2010 at 11:19am

maybe try dd/MM/yyyy instead of dd/mm/yyyy?

[SOLVED] DateTimePicker Display Bug!? : Hi,I have resolved my issue however...

Wed, 25 Aug 2010 05:21:24 +0000

Author: Xander75
Subject: 17154
Posted: 25 August 2010 at 5:21am

Hi,

I have resolved my issue however I am not sure if the above mentioned is a bug or not as the month in CustomFormat "dd/mm/yyyy" is displaying as "00" so I will leave this open for now...

I managed to make the DateTimePicker display as blank and then display the correct date on change by using the following code:


Private Sub Form_Load()
    With dtpDateOfRequest
        .Value = Format$(Date, "dd/mm/yyyy")
        .Format = xtpPickerCustom
        .CustomFormat = " "
    End With
End Sub

Private Sub dtpDateOfRequest_CloseUp()
    dtpDateOfRequest.Format = xtpPickerShortDate
End Sub

[SOLVED] DateTimePicker Display Bug!? : Hi,I am using several DateTimePicker...

Wed, 25 Aug 2010 04:57:17 +0000

Author: Xander75
Subject: 17154
Posted: 25 August 2010 at 4:57am

Hi,

I am using several DateTimePicker controls on a form and my requirement initally is to have these blank so the user must enter a date. I have done this using the following code in the Form Load event:


Private Sub Form_Load()
    With dtpDateOfRequest
        .Format = xtpPickerCustom        
        .Value = Format$(Date, "dd/mm/yyyy")
        .CustomFormat = " "
    End With
End Sub

So far so good, the control is blank and all seems fine... until I try and select a date, without setting the CustomFormat to "dd/mm/yyyy" I get no date appearing in the control so using the following code I get the date to appear, however the date displays as "25/00/2010":


Private Sub dtpDateOfRequest_Change()
    Debug.Print dtpDateOfRequest.Value
    dtpDateOfRequest.CustomFormat = "dd/mm/yyyy"
    Debug.Print dtpDateOfRequest.Value
End Sub

The Debug.Print lines cleary print the date as "25/08/2010" but the control displays "25/00/2010", is this a bug or am I doing something wrong?

Thanks...