469,964 Members | 1,731 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,964 developers. It's quick & easy.

Strang behavior 'Find & Replace'

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
Nov 7 '06 #1
2 1410
"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
Nov 7 '06 #2
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
Nov 8 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by hehongyu2000 | last post: by
11 posts views Thread by Gustavo G. Rondina | last post: by
7 posts views Thread by Mike Livenspargar | last post: by
7 posts views Thread by John Nagle | last post: by
3 posts views Thread by Crash | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.