find BLANK and replace with my text

  • Thread starter Thread starter sarah
  • Start date Start date
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
 
Sarah,
Use an Update query.
Use...
Where (((YourFieldname) Is Null))
as the criteria to find the blanks in your particular field.
hth
Al Camp
 
I prefer to use the criterion:

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

which will pick up Null and white spaces.

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