Replace Blank cells with text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

laWhen I filter a table within access, I want to take blank cells in a column
and add the same text to each cell. Its a Find / replace action, but you
cannot leave the 'find' field blank. Is there a way around this.

Thanks
 
RC said:
laWhen I filter a table within access, I want to take blank cells in
a column and add the same text to each cell. Its a Find / replace
action, but you cannot leave the 'find' field blank. Is there a way
around this.

Thanks
Click to expand...

"is null" and "is blank." They are not the same thing. You may need to
search for both.
 
If you want to actually change the value that is stored in the table, you
can do it with an update query ...

UPDATE tblTest SET tblTest.TestText = "Some Text"
WHERE (((tblTest.TestText) Is Null)) OR (((tblTest.TestText)=""));

Alternatively you could leave the stored value as is, and just display an
alternative text ...

SELECT IIf([TestText] Is Null Or [TestText]="","Some Text",[TestText]) AS
AltText
FROM tblTest;

If you're not familiar with SQL, here's how these queries look in query
design view ...

http://brenreyn.brinkster.net/query1.jpg

http://brenreyn.brinkster.net/query2.jpg
 
These two terms do not appear to work for me. I am using Access 2000. Does
that make any difference?
 
Incase some of the fields contain spaces but no value, such as " ", the add
to the update Query that Brendan provided

UPDATE tblTest SET tblTest.TestText = "Some Text"
WHERE tblTest.TestText Is Null OR trim(tblTest.TestText)=""
 
Back
Top