Retro Filling Blank Cells 2

[JohnieR]

Is there a way of retrospectively filling any empty cells that may remain in a single (text) field of an Access 2000 table - say an X or even a few words? Many thanks in advance to anyone who can help.

 

[JohnieR]

Apologies for my confusing terminology. I meant "single (text) column".

 

[jebry]

Hi!

Try writing an update query. In the QBE select your table and then select the field you want to update. Click on the query type button, next to the run button, and select update query. Set the update to to IIf(Nz(Len(

![Field]),0)=0,"Your filler here",

![Field]). This will keep whatever is there and add your filler if the field is blank.

hth
Jeff Bridgham

 

[JoeMiller]

A better way would be to make the update query, put the thing you want to appear in the field in quotes (ie: "BLANK&quot and then place criteria on the field below like this:

Is Null OR ""

HTH Joe Miller
joe.miller@flotech.net

 

[dbdave]

I vote for joe's solution... simply and less prone to typo's.