Unchecking the Windows Themed Controls option by code

[fluffyozzy]

Hope someone can help me with this )

I have a tabbed form on a database back style of which is set to transparent and works great when I uncheck the box "Use Windows Themed Controls on Forms" option in Tools > Options. Is there any way to uncheck this option automatically by a piece of code on, say, OnOpen event or something?

The database will be travelling quite a bit and put on various machines and we have a "dark background" requirement (and none of the Windows menus will be visible to the user anyway).

Any coding help or advise would be much appreciated.

Thank you very much in advance )

 

[Banana]

If you look in VBA Editor's help for "Set Options" you get a listing of options you can use to manipulate properties as you see in the Option windows.

So for your case:

GetOption("Themed Form Controls")

To tell you what state it is in right now.

To change it:

SetOption("Themed Form Controls", 0)

 

[fluffyozzy]

Oooh, that sounds nice and simple, just the way I like it

Thank you very much