Microsoft Access 2010 Bible

Chapter 29: Customizing Access Ribbons

1037

The imageMso_Galleries example database includes frmSelectRibbonGallery (shown

in Figure 29.23) to dynamically load any of the six Gallery ribbons in the database. Select a Gallery

using the buttons on this form, and the Gallery tab appears to the right of the default Access rib-

bon tabs.

FIGURE 29.23

frmSelectRibbonGallery dynamically loads the ribbon Galleries in imageMso_Gallery.accdb

Gallery tab

Galleries tied to these forms Select a Gallery

imageMso_Galleries also include a form for each of the ribbon Galleries. Opening any of

these forms (frmGallery01, frmGallery02, and so on) dynamically loads the ribbon associ-

ated with the form. (A form’s custom ribbon is specified by the form’s Ribbon Name property.)

The Label control

The Label control is, by far, the simplest and easiest to add to a ribbon. A ribbon label is com-

pletely analogous to a label you add to an Access form. It contains either hard-coded text or text

that is generated by a callback procedure.