I am trying to assign a Macro that I recorded to a command button. However
when I right click on the sizing bar of the command button "Assign Macro"
does not appear. Is thare another way to do this?

You used a commandbutton from the Control toolbox toolbar.

Delete that one and add a button from the Forms toolbar.

Dave wrote:

I am trying to assign a Macro that I recorded to a command button. However
when I right click on the sizing bar of the command button "Assign Macro"
does not appear. Is thare another way to do this?

--

Dave Peterson

I'm not sure if there is anything against doing this (as I've been doing it
this way for some time), but you can go to 'View Code' and then just type
the name of your macro. That should run your macro when the button is
clicked.

HTH,
Paul

"Dave Peterson" wrote in message
...
You used a commandbutton from the Control toolbox toolbar.

Delete that one and add a button from the Forms toolbar.

Dave wrote:

I am trying to assign a Macro that I recorded to a command button.
However
when I right click on the sizing bar of the command button "Assign Macro"
does not appear. Is thare another way to do this?

--

Dave Peterson

Personally, I like the buttons/controls from the Forms toolbar for most things.
I find that they're "lighter" than their counterparts from the control toolbox
toolbar.

PCLIVE wrote:

I'm not sure if there is anything against doing this (as I've been doing it
this way for some time), but you can go to 'View Code' and then just type
the name of your macro. That should run your macro when the button is
clicked.

HTH,
Paul

"Dave Peterson" wrote in message
...
You used a commandbutton from the Control toolbox toolbar.

Delete that one and add a button from the Forms toolbar.

Dave wrote:

I am trying to assign a Macro that I recorded to a command button.
However
when I right click on the sizing bar of the command button "Assign Macro"
does not appear. Is thare another way to do this?

--

Dave Peterson

--

Dave Peterson