Software

Ask something
Discussion Locked

Find/replace functions different in 2000

0 helpful
3 replies

by ideafixer 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

The edit find in 2000 works differently in 97 when used from a form. In 97 you can uncheck current field, and the feature will check the entire table for the value specified.

In 2000 you cannot do this from a form. When in a form, it will either check all records for a specific field or all fields on the current record.

I want to check all fields for all records on a form.

The only time I could check all the fields for a certain value is when I had the table open in 2000. With the table open I can change the "Look in" to the actual table not the field selected.

How, in a form, can I use edit find to search all fields for a certain value? I am suprised they changed this. I want the search to funtion like 97s.

Help!

3 replies

by dklippert

In a form, click the binoculars on the toolbar. Drop the list dwon next to "Look in" and it will let you search the whole table.

by ideafixer

That is the interesting part. When clicking the binoculars, I only get the option to search the current field or the form. Basically, I can search each field of the current record or all records for one field. In an access 2000 form searching allfields for all records for a value on a form does not appear to be available. If I open the table, I can search the all fields for a certain value. It's when the search tool is used on a table hooked to a form.

This discussion is closed to new replies.