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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,223,229
Messages
6,170,881
Members
452,364
Latest member
springate

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