I need to scan a table and update all blank fields to "BLANK". Ideally I would like to do this with an update query, but am willing to use vba if necessary. Thanks for any suggestions you are willing to offer. .................Phil Hoop
I need to scan a table and update all blank fields to "BLANK". Ideally I would like to do this with an update query, but am willing to use vba if necessary. Thanks for any suggestions you are willing to offer. .................Phil Hoop
If you use something like Nz(fieldname,"") = "" in the criteria for the field to be updated it should work. I used Nz in case the "blank" field can be either Null or an empty string.
Thank you John_G. I tried your suggestion, but unfortunately it didn't work. After a couple of hours of trial and error I finally stumbled onto something that did work. It was an update query that updated the Field = 0 when the Len(Trim([fieldname]) & "") Criteria = 0. Hopefully this may save some access user a bit of frustration in the future. Thanks again. ..................Phil Hoop