Form Button to Execute Disabled Ribbon Command

[stwalke2]

Hi,

I am trying to create a button on a popup form that will start a numbered or bulleted list in a textbox (memo style). Below is the "Onclick" event I have for the button (it sets the focus of the text box first).

Application.CommandBars.ExecuteMso ("Bullets")

This works only if the form is NOT a popup form as onfocus of the textbox the "bulleted list" button in the ribbon becomes enabled. However, in a popup form, the button is disabled no matter what so an error occurs and no bulleted list. Is there a way to enable the command or make it so I can start a bulleted list when a button is clicked?



And no, I don't want to have a customized ribbon...I'd rather have no ribbon and just the form with a few select commands available as buttons on the form. I've also tried the sendkeys command; it fails.

Thanks for your help.

[June7]

Your options might be:

1. don't set form as popup

2. use Chr(149) in the text string

[stwalke2]

June7,

Thank you for the suggestions. Unfortunately, that isn't a solution I can use. I want to use a popup form so I can hide the rest of Access. Now if I can do that without having to use popup, I'm good with that. Using Chr(149) doesn't get what I need.

[June7]

I have doubts the RTF tool group can be made available. Not even sure a custom ribbon could be configured with them.

[stwalke2]

Well I appreciate the help. Any other suggestions out there? I've seen forms with "save" records and things like that but I don't think that is calling a ribbon function. The only one I really need is the Bulleted List function.

[stwalke2]

Anyone else have ideas for this? It seems like it would be an available feature in Access.