Can't use Listbox with AllowSpecialKeys=False

[jimatqsi]

Trying to control the environment so user's can't get into my queries is driving me up a wall and making me say 3-letter words like 'dam'. Arrrrggghhh!!

I use the command

CurrentDb.Properties("AllowSpecialKeys")=False

in menu OnLoad event. Now, all the listboxes in the menu are dead. Clicking on a selection is useless. Take the above command out and the listboxes come back to life.

Using Access 2010 but with db format of Access 2007.

And I can hide the navigation window in the .accdb version (until they hit "specialkey " F11!!) but when using the Runtime version .accde I cannot hide the nav window. What gives with that?

Has anyone solved these problems?

Jim

[twinnyfo]

Jim,

Have you tried setting the AllowSpecialKey s property from the Main DB options? I turn mine off programatticall y when I create my MDE file, but haven't had any issues like you describe.

[jimatqsi]

Yes, I have tried that. It made my listboxes become "dead"; they didn't respond to clicks. Now that is not the case. I just ran a test, and after setting the main db option to turn off special keys my list boxes still work.

I'm not sure what's different. I think it is related to some code I wrote to hide the database window. I took that out and set the option in the main db options to hide the window. But I should have been able to do that programatically without putting my listboxes to sleep.

I'm confused.

Jim

[twinnyfo]

Note my avatar--scratching my head. Some things just don't make sense.