strongm,
I started over and tried your suggestion again and it did work! It didn't make sense to me that the other solution I found worked and the coding was so close to matching what you had. Since your code is shorter than the other solution I found, I will go with it. Problem solved...
I originally did use the code as given, which is how I have restored it now. But nothing happens. That's the only reason I was trying other solutions, because what you originally posted did not work for me. Are you using any special references or anything? It just is not changing the height...
Correction: When I used the exact code you provided, I didn't get any changes. But when I used this:
form1.scalemode = vbpixels
combo1.width = 750
...I got the larger width so that was my mistake. I tried:
combo1.height = 750,
But it says height is a read-only property. What did I do wrong...
I'm actually not looking for "additem". Let me explain a little more, maybe that will help:
I have a sql script that populates this combo box. Let's say the script comes back with 30 records & they are all added to the box (I use the .additem code to do this actually).
What you then...
My manager has requested that I change the number of items showing on a combo box in my program from the normal 8 to a larger number. In other words, she wants to be able to see more data at a time when she clicks on the arrow. Is this possible?
You are right, when I get to A0000000000000000009, it does not go to A0000000000000000010 it goes back to 1. But this code you gave me does not change to the next available number, it stays the same.
Found my answer. My label is 20 characters, and this is how I formatted the next number:
lblAuditor2 = Mid(lblAuditor2, 1, 1) & _
Right(Left$(String$(18, "0") & Mid(lblAuditor2, 2, 19) + 1, 19), 19)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.