Access 2010 ribbon

Andy Brown
Andy Brown used Ask the Experts™
on
I have a database that has been built in Access 2003.  I tried to port it to 2007, but found that the Ribbon took up too much screen space and I only need a thin bar of icons going across the top of the form.  I have heard that 2010 allows you to change the height of the ribbon.  Is this correct?

Thanks for your help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Adam MenkesC# ASP.NET Developer
Top Expert 2010

Commented:
You could also remove the ribbon if you don't want it.
DoCmd.ShowToolbar "Ribbon", acToolbarNo
Andy BrownDeveloper

Author

Commented:
I could, but I need the icons and it never looks as good when you try and fudge it with buttons.
Adam MenkesC# ASP.NET Developer
Top Expert 2010

Commented:
What I do is this (which also disables the holding of the shift key to get to your tables/code/etc):

  If IsRunTime() Then
      DoCmd.ShowToolbar "Ribbon", acToolbarNo
      result = CurrentDb.CreateProperty("AllowBypassKey", DB_BOOLEAN, False)
   End If
Adam MenkesC# ASP.NET Developer
Top Expert 2010

Commented:
I do the above, and then create my own ribbon. I will post an example shortly.
Andy BrownDeveloper

Author

Commented:
Thanks for your help - much appreciated.  

Can you adjust the height of the ribbon, which I think is key for this app.
Adam MenkesC# ASP.NET Developer
Top Expert 2010

Commented:
I have not done it, but it appears possible, based on this link: http://www.aspfree.com/c/a/.NET/The-Windows-Ribbon-Framework/2/

You may have to find the window handle and do some Windows API calls, unless someone has a simpler solution.
Andy BrownDeveloper

Author

Commented:
Why is nothing ever straightforward......:O).

I'll do a bit of routing around and come back if I find/get the fix.

Thanks for your help once again.
Andy BrownDeveloper

Author

Commented:
I've had a quick look and so far haven't found anything I can use.  One chap claims that not using the Ribbon in its intended format is old fashioned and I do understand where he is comming from.  However, this application has a total of 20 icons (with captions) that is all the user needs to see - So the Ribbon height is overkill.

I don't want the user to have to minimise / grow the ribbon as it is inefficient for this type of app.

Rant over.....

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007
Commented:
"So the Ribbon height is overkill."
The Ribbon is the number 1 downside to O2007/O2010.  

mx
Andy BrownDeveloper

Author

Commented:
I don't get irritated by too much - but this one.......and it's not as if nobody has mentioned it on the bloggs / focus groups.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
I am spending soooooooo much time just looking for stuff in A2010 it's insane.  A total waste of my time.  

mx
Adam MenkesC# ASP.NET Developer
Top Expert 2010
Commented:
In a way though, it makes sense. Microsoft has made Access and the whole office suite of products (Word, Excel, etc) use a ribbon, so it has a consistent look and feel. If the Ribbon were made too small, it wouldn't look like a ribbon. Since multiple tabs can be added, and different controls enabled / disabled, visible / hidden (including tabs and groups), a lot of the functionality can be moved off of the main form and into the ribbon.

So, yes it takes more space, but it also should free up space in your forms. Otherwise, I would hide the ribbon and handle the functionality differently.

Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
The Ribbon is the thing DEVELOPERS hate the most. Most standard users seem to like it just fine, assuming we (as developers) provide them with the correct choices for the current activity. At least that's been my finding from my (very unscientific) surveys (i.e. ask the users "Hey, what do you think of the ribbon interface?").

I was like MX when I first started with 07, but once I got into the whole Ribbon thing I found it to be pretty simple to use, and I like the ease with which you can customize it. Some of it is a bit irritating, but then so is any new technology. Of course I prefer the older toolbar/menu stuff, but then I've used it for many years and am comfortable with it. I'm sure in a few years we'll all say "Yeah we used to fuss about that too". As they told us at the Summit - "Love it or hate it, the Ribbon is here to stay."
Andy BrownDeveloper

Author

Commented:
I see everyones point of view, and agree from a users point-of-view the Ribbon is just fine.  But for this database it's just too much as I couldn't think of enough things to fill it with.  For me, it would have been perfect if I could have reduced the height - just a little.

Thanks everyone for your help on this one.

Commented:
This does not work in 2010
Andy BrownDeveloper

Author

Commented:
Thanks for the info.

I'm starting to think about porting the front-end over to .Net (a job I am not looking forward to).  But at least this way, I'll have much more control over everything like that.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial