Community
Showing results for 
Search instead for 
Do you mean 
Reply

REPLACE YES/NO FIELDS IN A LOOKUP

Accepted Solution Solved
Copper Elite Contributor
Posts: 175
Country: USA
Accepted Solution

REPLACE YES/NO FIELDS IN A LOOKUP

Is it possible to create a lookup and then replace a Yes/No field value from no checkmark (no) to a checkmark (yes)? I can't figure out how to do it. I'm assuming that because it pulls down in the menu as a field to replace, it must be possible. Am I suppose to use a special character?  I've tried several. Nothing has worked.


Accepted Solutions
Solution
Accepted by topic author tbudde
‎09-25-2015 03:20 AM
Copper Elite Contributor
Posts: 175
Country: USA

Re: REPLACE YES/NO FIELDS IN A LOOKUP

Thanks!!!  It worked. Slightly diferent though. To make the change, I had type in the word True. There was no box to check. Worked great.

View solution in original post


All Replies
Nickel Contributor
Posts: 410
Country: Canada

Re: REPLACE YES/NO FIELDS IN A LOOKUP

Create a lookup of all "No" values.

Then click Edit from the pull-down menu, then "Replace Data"", and then select the checkbox field on the left you wish to change, and then type TRUE".

Obviously this process is reversed for clearing a lookup of checked boxes.

 

Hope this helps.

 

Ken Quigley, BA, MCSE, ACC, APT
Toronto, Ontario
www.keystroke.ca
Solution
Accepted by topic author tbudde
‎09-25-2015 03:20 AM
Copper Elite Contributor
Posts: 175
Country: USA

Re: REPLACE YES/NO FIELDS IN A LOOKUP

Thanks!!!  It worked. Slightly diferent though. To make the change, I had type in the word True. There was no box to check. Worked great.