Yes, actually I noticed that myself after my reply. The routine does retrieve a value, although I don't know what the unit of measure is. And, if I change the height of the ribbon and then run the routine again, it returns the same original value, not the new one. I have to close and reopen the database for the change in height to be recognized.
Stuart
On Thursday, August 28, 2014 5:30 PM, "yahoo@craven.de [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
That's probably because an extra space character has crept in, it should say "Ribbon" and not " Ribbon"
In the debug window doing
?Application.CommandBars(" Ribbon").Controls(1).height
will give you the error whilst
?Application.CommandBars("Ribbon").Controls(1).height
will give you something like 146 or 55
__._,_.___
Posted by: Stuart Schulman <stoughy@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (46) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar