Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trouble getting rid of text

    I imported a access file -the word NO is listed under Exp if the person did not die. I can not get rid of the word NO. There is no default value listed. I get a popup saying "You can't replace the current value of the field with the replacement text." I'm doing a find and replace with nothing- but even if I try to put in anything I still get this popup.
    Please help

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Chances are you are dealing with a binary (Yes/No) field, and in those cases you can't really do a find and replace. If you look at the table design you can determine if that is the case.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •