The routine returns 150 for ribbon height. Doesn't look like twips or inches....
S
On Friday, August 29, 2014 1:29 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Unit of measure is probably Twips - 1440 Twips to the inch.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Aug 29, 2014, at 3:53 AM, Stuart Schulman stoughy@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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 (48) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar