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

  • Thread starter Thread starter Mary
  • Start date Start date
M

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!
 
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)
 
Worked like a charm, thank you so much! :)

KARL DEWEY said:
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 said:
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!
Click to expand...
Click to expand...
 
Back
Top