Hilary has attended:
Access Intermediate course
Access Advanced course
Access Introduction course
Find and replace
I have a large databse with about 15,000 records. When I try to find and replace text in a table, how come it doesn't search the entire database and I have to run the find/replace quite a few times to change all?
RE: find and replace
Dear Hilary
Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.
When you use find/replace normally it only replaces the data in the field where the cursor was blinking.
If you want the data on the entire table to be replaced then you need to click on the drop down arrow of Look In of the Replace dialog box. Choose the name of the table and then choose replace all.
Please be very careful of this option as it will replace the entire data in the table. Thgere are some cases where you might not want to replace every singe entry!!
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
