Need button to bring up customized Find box

[M Skabialka]

I have a database where one of the fields is a memo field, copied from info
sent to us as a document, but we don't need the formatting since the info is
more important. Since this can be quite long, I would like to add the
ability in the form to click on a button which brings up a Find box for that
memo field only. When I do this with CTRL F while in the memo field, the
Look In is to this memo field, Match is to Whole Field, and Search is All.
(Although I think these may match the last time a Find was run).
How can I make it default to Match "Any part of Field" rather than "Whole
Field" always? I want a button to be clicked to bring up this modified find
dialog box. What would the code behind this button be?

Thanks,
Mich

 

[Peter Hibbs]

Have a look at the section "Have Access search the way you want by
default (95/97/2000)" at -

http://www.computerbooksonline.com/tips/access2.asp

HTH

Peter Hibbs.

 

[M Skabialka]

I tried this, and chose "General Search" which does show me the Find box
looking in any part of the Field when I use CTRL F, but now it wants to
search the entire subform, and it still isn't in a button.

How do I create a button to open the Find box, with the find set to look
only on that one memo field, any part of the field, in all directions?
I tried a DoCmd.FindRecord(..tried all sorts of variations here...) but
couldn't make it work at all.

Thanks,
Mich