Strang behavior 'Find & Replace'

[john]

In a table I have text field A. I would like to replace all the null values
in field A to a real value, let's say 'Test'. When I use Find & Replace and
I search for 'is null' and I press replace or replace all, no null value is
found, so I can't replace anything. However, when I press Find Next in that
same dialog then the null values are found.
Anyone and idea what is happening here?
Thanks,
john

[Fred Zuckerman]

"john" <jo**@test.comwrote in message
news:oc******************************@casema.nl...

In a table I have text field A. I would like to replace all the null

values

in field A to a real value, let's say 'Test'. When I use Find & Replace

and

I search for 'is null' and I press replace or replace all, no null value

is

found, so I can't replace anything. However, when I press Find Next in

that

same dialog then the null values are found.
Anyone and idea what is happening here?
Thanks,
john

I have found that the Replace function doesn't work unless you begin on an
appropriate record. So I alway click 'Find Next' then I click 'Replace' or
'Replace All'. Try this and let us know if it works properly for you.
Fred Zuckerman

[Tim Marshall]

john wrote:

In a table I have text field A. I would like to replace all the null values
in field A to a real value, let's say 'Test'. When I use Find & Replace and
I search for 'is null' and I press replace or replace all, no null value is
found, so I can't replace anything.

I would think that typing in "is null" into the F&R dialog would look
for records that had the words "is null" in the field.

It's far, far more appropriate and really much easier to run an update
query. Are you familiar with the query builder and how it's used? Put
"is null" in the criteria of the field you wish to replace.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me