ghost data?

[technoranger]

I have a database with eight fields (S_a - S_h) set up as checkboxes drawn from eight separate value lists (S_a - S_h). I created a separate layout to display the selected contents of the fields with a calculation of, for example, GetAsText (S_a). The problem is that some of the displayed content does not match the boxes checked (a checkbox field may have 3 of 8 values selected but displays 6) and, in one case, contains a value deleted from the list.

Any idea of a better way to see only the values checked?

[comment]

Your calculation field shows you the actual contents of the checkbox field. You can see the same result without the calculation - just duplicate the checkbox field and format it as an edit box.

Formatting a field as a checkbox set acts like a filter - only values included in the value list are displayed. But this is for DISPLAY only - the other values are still there.

You COULD achieve the same result in a calculation using the FilterValues() function - but you would be lying to yourself again. I believe you should clean up your data, instead of sweeping the mess under the rug, so to speak.