Checkbox magic needed... (remove...)

[Mary]

I am convinced, we seriously need to ditch our checkboxes. But I'll need to
be able to have a report form that looks like we use checkboxes.

Let's say that I create an "employment" field that allows a certain set of
entries via dropdown list. Is it possible to make a report show the list of
entries, and look like it has checkboxes for all the different entries, but
only the valid one is checked and the others show a box that has no checkmark?

If so, I am going to celebrate. Help is appreciated!

 

[KARL DEWEY]

Use an IIF statement for each report display checkbox --
Check box 1 --
IIF([FieldX] = 1, -1, 0)

Check box 2 --
IIF([FieldX] = 2, -1, 0)

Check box 3 --
IIF([FieldX] = 3, -1, 0)

 

[Mary]

Worked like a charm, thank you so much!

Use an IIF statement for each report display checkbox --
Check box 1 --
IIF([FieldX] = 1, -1, 0)

Check box 2 --
IIF([FieldX] = 2, -1, 0)

Check box 3 --
IIF([FieldX] = 3, -1, 0)

I am convinced, we seriously need to ditch our checkboxes. But I'll need to
be able to have a report form that looks like we use checkboxes.

Let's say that I create an "employment" field that allows a certain set of
entries via dropdown list. Is it possible to make a report show the list of
entries, and look like it has checkboxes for all the different entries, but
only the valid one is checked and the others show a box that has no checkmark?

If so, I am going to celebrate. Help is appreciated!