Adding a toolbar to a form

[randle]

Hi

Can someone tell me how I can add a toolbar ie. Format options, to a specific form in Access 2010. Is this actually possible?

 

[vbaInet]

The user interface (and the user experience ) changed from Access 2007 and above. Toolbars (and Menubars) have become an obsolete feature in those versions. Access 2010 uses ribbons in place of toolbars so if you want custom menus you will need to customise the ribbon.

However, if you create toolbars in older versions of Access you can still use them in Access 2007+

 

[randle]

Many thanks for the reply. I'm aware that the ribbon replaces toolbars but was hoping it was still possible to add a toobar of some sort to a modal form that the ribbon can't be used on.

Basically I want to add the format text options to the form rather than using the context menu that appears when highlighting text. I know this is the same but doesn't always appear on queue.

 

[vbaInet]

Even if you add toolbars they will remain on the ribbon

Create some buttons in the Header section of the Pop-up form and get it to do what you want.

 

[randle]

Good idea. Care to tell me the code for making highlighted text in any field on a form bold!? I've tried "Me.Selection.Font.Bold = TRUE" and variations of this but not joy!!

 

[vbaInet]

What view is your form in?

 

[randle]

Single Form.

 

[vbaInet]

You will need to loop through the Controls collection of the form and change the FontBold and FontWeight properties.

 

[randle]

Sorry for being a little dumb but how do I loop through the controls collection of the form? Am I creating a macro for this button and setting the command from this?

 

[vbaInet]

You're going to use code. Here's some aircode:

dim ctl as control
 
for each ctl in Me.Detail.Controls
    select case ctl.controltype
        case actextbox
            ctl.fontbold = true
        case else
            ' do nothing
    end select
next

So what you do is manually set the Font Weight property of all the textboxes to Bold and set the Font Bold property to No. When the code runs it will simply switch the bold property back on.

 

[randle]

Thanks for this. Think I'm going to leave this seeing as I'm after the full suite of formatting buttons which seems more hassle that it's worth when I can access these from the context menu that appears when highlighting text. Thanks for your help though.

 

[vbaInet]

No problem.

Happy developing!