Supress Find or Replace Function

[mbentley]

Three questions regarding the built-in Find/Replace function:

1. Can it be turned off? I have disallowed special access keys and it is not part of my menus or toolbars, but ctrl+f or ctrl+h still brings up the Find/Replace dialog.

2. If the user uses the replace feature, I'm assuming that it would circumvent any field-level data integrity code. Correct?

3. Given 2, is there any way to allow Find, but not Replace?

Thanks

 

[ghudson]

I suggest that you create an AutoKeys macro to do what you want. Below are the Macro Names that you want to disable the Ctrl + F and Ctrl + H keyboard combos...

^{F}
^{H}

You can use any action that you want. Like call a message box to alert the user that those keyboard combos have been disabled.

Search the help files for the AutoKeys macro for more info and examples.

HTH

 

[mbentley]

Thanks. Looks simple enough. Is there anyway to do this through VBA?

 

[ghudson]

Not the way that you want to use it. There are only two macros that I allow in my db's... AutoExec and AutoKeys for they do what VBA can not once you have disabled the Shift key.

 

[mbentley]

Yeah...I was trying to avoid macros. Just set it up...works like a charm. Thanks.