Update query

[Tom]

Hello,

Can someone tell me how to replace blank text fields with the word "none"
in Access 2000, I imagine it's an "Is Null" query then an update query with
"none" in the update field but I'm new to Access so an "idiots guide" type
answer would be much appreciated. I don't suppose find and replace would
work would it?

Thanks in advance

Tom

 

[Jeff Boyce]

Tom

A 'blank text field' could be Null, or could be a zero-length string ("") or
could even hold spaces ... all appear the same to casual inspection. I
believe Access will help with the latter, by 'squeezing out spaces'.

An update query could do what you're describing, but you may wish to test
(i.e., selection/criteria) for both null (Is Null) and for zls ("") before
updating to "none".

Yes, a find/replace might work... the update query is a preferred approach
(but that may only be my opinion...)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tom]

Thanks Ken and Jeff. It worked perfectly.

Much appreciated

Tom