By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,296 Members | 1,472 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,296 IT Pros & Developers. It's quick & easy.

Strang behavior 'Find & Replace'

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
"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

P: n/a
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.