Filling a column with the same value when the table is filtered on the same column as 'empty'

[Kevin_Johnson]

I am trying to fill a filtered column with the same text value, but the table is filtered on the same column as ‘empty’. When I add the text to the first row/cell, the row then disappears because the cell is no longer empty. Then I have no way of automatically filling the remainder of the column with the same text value.

[ScottWorld]

It doesn’t actually disappear until you leave the record, so it still gives you a chance to edit the other fields before it disappears.