Find and replace - option

L

Lucas

HI there, I have a question about find a replace box in a
form.

At the moment, when I open the "find and replace" option,
the default value in option "look in" is set for a
specific field, and the value for "match" option is set
to "Whole Field".
I would like to modify the "find a replace" option so that
when I open it, I would like 2 fields of a form as a
default for "look in" option and in the "match" option I
would like to set it to "any part of the field". The
reason for this is that I would be looking in two fields,
one of them would be a text field and the other one would
be a number.

Can anyone give me some clues to how to set these
requirements in the "find and replace" option, please?

Just let me know need a clearer explanation, as I can be
confusing when I explain things.

Best regards,

Lucas
 
R

Rick Brandt

Lucas said:
HI there, I have a question about find a replace box in a
form.

At the moment, when I open the "find and replace" option,
the default value in option "look in" is set for a
specific field, and the value for "match" option is set
to "Whole Field".
I would like to modify the "find a replace" option so that
when I open it, I would like 2 fields of a form as a
default for "look in" option and in the "match" option I
would like to set it to "any part of the field". The
reason for this is that I would be looking in two fields,
one of them would be a text field and the other one would
be a number.

Can anyone give me some clues to how to set these
requirements in the "find and replace" option, please?

Just let me know need a clearer explanation, as I can be
confusing when I explain things.
Click to expand...

You need to understand that since Access can be used by "non database"
people for fairly basic things like contacts lists, CD collections etc., it
includes many GUI tools targeted at that user-type. It also includes many
tools and methods for the more advanced user who would be developing more
of a "professional level" application. Most such applications would never
use the GUI methods that are there for the "non database" type user.

I mention the above because you are basically attempting to do something
advanced with the Find and Replace dialog which would be an unusual thing
for a professional developer to do because he/she would not likely be using
the Find and Replace dialog in their application in the first place. They
would be writing an update query or VBA code routine to accomplish the
task. That being said, you would be more likely to get assistance in doing
what you want in a manner that doesn't involve using the F & A dialog.
 
Top