Hello!

I’m new to Access and following a tutorial online and am at a point where they are teaching how to assign macros to command buttons.

In the tutorial, when the click the “ellipsis button” on the Property Sheet…

a dialogue box pops up with options for different “builders” to choose from.

However, this does not happen for me. When I click the button it automatically opens the VBA window.

Is there a way to change this behavior? I looked through the options but didn’t see anything.

I’ve figured out I can create the macro separately and then assign it to the command button, so I have a workaround; but being able to use the Property Sheet while I’m designing a form seems much more convenient.

I’m using Access with Microsoft 365 on Windows 11.

Any info or advice would be greatly appreciated.

Thank you! 

​Hello! I’m new to Access and following a tutorial online and am at a point where they are teaching how to assign macros to command buttons. In the tutorial, when the click the “ellipsis button” on the Property Sheet…a dialogue box pops up with options for different “builders” to choose from.However, this does not happen for me. When I click the button it automatically opens the VBA window. Is there a way to change this behavior? I looked through the options but didn’t see anything. I’ve figured out I can create the macro separately and then assign it to the command button, so I have a workaround; but being able to use the Property Sheet while I’m designing a form seems much more convenient. I’m using Access with Microsoft 365 on Windows 11. Any info or advice would be greatly appreciated.Thank you!   Read More

​