Enter the same text into all blank cells in a column

[Sean]

I want to add a entry ***NOT VALID*** into all the blank cells in one column
Does anyone know of a easy way to do this in access without having to copy
and paste 1500 times

Kind Regards

Sean...

 

[Al Campagna]

Sean,
I assume this field in your table is a Text field?
Create an Update query that, if null, puts your "***NOT VALID***"
string into that field.

Better yet, code your entry form for that table... to not allow that
field to be left null. (make it a required field)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Sean]

Many thanks that worked a treat, I knew there was a simple answer, but didn't
quite know where to look. all future enteries have the default value set
brilliant thanks