Change Microsoft Access Theme Colors (Blue Warm, Blue, Grayscale, …) using VBA RRS feed

  • Question

  • Hello,

    I want to create a combo box that contains a list of the built-in default theme colors, and be able to change the theme using VBA.

    Thank you for your help.

    Tuesday, July 16, 2019 5:27 PM

All replies

  • Hi Toni,

    Considering your question is mainly related to using VBA in Access, to help you better resolve the problem, I will move the thread to Access for developers Forum. You may get more help replies there.

    Thanks for your kind understanding.

    Best Regards,


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Wednesday, July 17, 2019 2:54 AM
  • This is a very large topic. Someone should write a book about it.

    In the meantime use the object browser and the help system, for example BackThemeColorIndex and ThemeFontIndex.

    There is a bunch of good info here: 


    -Tom. Microsoft Access MVP

    Wednesday, July 17, 2019 4:33 AM