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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher is filling blank lines with data 2
PRINTING handiest filled statistics 0
Blank Page After Envelope-Label Wizard 5
Word 2007 flash screen upside down and Word2007 cannot be used 0
How to display zero value in blank fields of Cross Tab query 0
Nested if statements creating a blank cell 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Matching literal text "???" in Word 2010 field code IF statement 2

Top