find BLANK and replace with my text

S

sarah

Hi- Hope you can help. I have many records where one field
is blank. I want to do a find and replace. Find the blank
field and replace with my desired data (which would be the
same for all returned records). How do I do a find and
replace on a blank? I've tried " " I've tired "*" I've
been keying in a gazillion 1's and then doing a find and
replace that way- works but on 2000+ records that is a
PAIN! Can you offer any remedy? Best Regards, Sarah
 
A

AlCamp

Sarah,
Use an Update query.
Use...
Where (((YourFieldname) Is Null))
as the criteria to find the blanks in your particular field.
hth
Al Camp
 
V

Van T. Dinh

I prefer to use the criterion:

.... WHERE (Trim$([FieldName] & "") = "")

which will pick up Null and white spaces.

--
HTH
Van T. Dinh
MVP (Access)
 
Top