Access - Filling Blanks

W

wal50

I have records that have blanks in one field. I want to put the same value
in all of them. How can I do this? Replace doesn't seem to work for Blank
fields

wal50
 
F

Frank Kabel

Hi
- select the data range
- hit F5, click 'Special' and choose 'blank cells'
- enter your value and hit CTRL+ENTER
 
Top