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
Does anyone know why I am losing the custom formatting on the date picker control?
Thank you for your time.
Jim
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