Datepicker NOT MONTHVIEW

[Guard913]

So, I like the Date Picker better than Monthview because it legit puts a drop down vs needing to build a whole new form (as the form it needs to be on is to small, and I have to select multi-dates , not gonna get into it)

1st: (If you can resolve this then ignore other requests)
How do I change the font size of Datepicker? There is no font option.

2nd:
I use Labels to make combobox's work better so i don't have to click on small arrow but rather set label on click to combobox1.dropdown so clicking anywhere on label will show drop down menu rather than being limited to just the button.

So if you can't fix my 1st issue, what is the code that when I click on label will show the datepicker calendar and then on selecting date hide datepicker and move the selected value both to the textbox (which it already does by default) and show date in label. (The last part I am 90% sure of how to do, but the first part I can't figure out.

Thanks!!!

 

[DanteAmor]

Select the Font property of the dtpicker, press the "..." button and there you will find the font size.

 

[Guard913]

Select the Font property of the dtpicker, press the "..." button and there you will find the font size.

View attachment 19969

OMG!! I swear the i looked through the list like 10 times and didn't see the font option lol.... WHY!!! lol

However.... Even though I changed the size the button still shrinks back down to small size (text stays same font button itself shrinks).... Refuses to keep the size i chose in the VBA editor?

 

[DanteAmor]

You should make the dtpicker control bigger as in my image

 

[Guard913]

You should make the dtpicker control bigger as in my image

What i mean, is I did make the dtpicker both the font and actual size of control bigger, but it kept reverting back after running form.... Font remained right size but the control shrank so while all other controls on page stayed the right size this one shrank in comparison to other controls (while keeping font at right size.)

 

[DanteAmor]

Maybe it's something from the version, because in fact in the dtpicker everything got BIG

 

[Guard913]

yea.... everything got big font ect.. but control it self shrank back down...

 

[DanteAmor]

Try in a new userform