Replace Blank cells with text

[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

 

[Joseph Meehan]

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

"is null" and "is blank." They are not the same thing. You may need to
search for both.

 

[Brendan Reynolds]

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

 

[Guest]

These two terms do not appear to work for me. I am using Access 2000. Does
that make any difference?

 

[Guest]

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)=""