date Picker custom format reverts to native format

TorontoJim

Board Regular
Joined
Mar 16, 2009
Messages
51
...and I use the term "native" for want of a better term.

I have a User Form with a MultiPage control. On different pages I have datePickers. The datePickers are set to a Format dtpCustom and the CustomFormat is "yyyy.MM.dd". This is the same for all the date pickers on all the multipages.

In the initialization, I set all the dates to Now(), switching between MutliPage.Value = x to set them all (as you have to make the page active to access the datePicker control).

Form loads and shows the dates in the format that I want. However, when I select a date, click the button to execute the code, going to any MultiPage page AFTER that finds all the dates reverting to "dd/MM/yyyy".

I have tried re-initializing the date pickers AFTER performing a procedure including hardcoding them

Code:
frmName.foo.Format = dtpCustom
frmName.foo.CustomerFormat = "yyyy.MM.dd"
frmName.foo.Value = Now()

Does anyone know why I am losing the custom formatting on the date picker control?

Thank you for your time.

Jim
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Forum statistics

Threads
1,216,082
Messages
6,128,709
Members
449,464
Latest member
againofsoul

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top