Skip to main content
Question

Checkbox Search and Replace

  • May 2, 2019 10:00 PM UTC
  • 0 replies
  • 37 views

Forum|alt.badge.img+8
I want to change the value on all checkboxes in a table (from "not selected" to "selected").

What value do I use for Search and Replace?
This topic has been closed for replies.

Forum|alt.badge.img+14
  • Qrew Corporal
  • May 2, 2019 10:03 PM UTC
Build a report of all the records that are going to be affected by this change.  Use the Search & Replace feature.  Choose the checkbox field from the drop-down selection; and set the from: value to FALSE and the to: value to TRUE.  Then click OK twice to update all the records.  The first OK will tell you how many records will be updated by the change; and the second will action the update and it will then tell you how many records were updated in the modal before you close it manually.

Forum|alt.badge.img+8
  • Author
  • Qrew Corporal
  • May 2, 2019 10:19 PM UTC
Worked like a charm!

Thank you,

Dirk