open the Find And Replace Dialogue with focus on a specific default column

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

Colin Hayes

Hi All

I have a Sendkeys function of ^f to open the Find And Replace Dialogue.

I'd like to modify it so that it opens with focus on a specific default
column.

Is this possible?



Best Wishes


Colin
 
Klatuu said:
You first have to set the focus to the control you want to use the find and
replace on.
Click to expand...


HI

Yes , I understand. I

It's just that when I use my sendkey command to open the dialog again ,
the focus is on a different column and means that I have to continually
navigate for it to search down the one I want.

I just need to always focus on the same one when I open it.

Can this be done? Maybe with a macro or SQL?



Best Wishes
 
I don't see the first part of your thread so if this is 'way off base
that may be the reason.

Where you have the code to open the dialog, precede that line with one
to set focus to that *control*, not "field".

For general use, there is (or was) a saver version of SendKeys on
www.mvps.org/access named fSendkeys.

HTH
--
-Larry-
--

 
Back
Top