find all empty current fields and add text to them?
Is it possible to search all "current fields" that are empty and add a text string?
Since you are only modifying a single field across all your records. Use Replace Field Contents instead of find/replace.
Make a back up copy of your file. (If you have problems with this type of operation you can't undo what you've done and you might have altered data in 100's of different records.)
Enter find mode
Put an = operator in the architect field
Perform your find. This should give you a found set of all records where "architect" is empty. If you don't see that on your layout, stop and report back here.
Enter "Unkonwn" into the architect field of one of these records and leave the cursor in the field.
Select Replace Field Contents from the Records menu and use the current value option to update your records.
What is your definition of "current fields"? All the fields in the current record that are visible on your layout? All the empty fields on the current layout across all records in your found set? or ??
It will take scripting to do this.
I still don't fully understand what you want.
Find/Replace can work on the current record or the current found set of records.
Which do you want?
Can you post an example of exactly what you want to do?
I have a DB in which several hundred records have the field "architect," which is empty. I would like to search for the empty "architect" field and put "unknown" in it.
Hi PhilModjunk, Fantastic. So simple when you know how to do it. Sorry for the late response, but I just got time to get back to this.
Retrieving data ...