Is it possible to view CheckBoxes in Pivot Table view

[Chipcom]

Hi

Is it possible to view CheckBoxes in Pivot Table view (I only see True or False)?
With datasheet view I can see them.

 

[llkhoutx]

Yes

It might display -1 and 0, in which case you'd have to use a conditional if to display True or False, i.e.

IIF([Checkbox]=-1, "True","False")

Always check a boolean against True because other possible values are Null and False (0).

 

[Chipcom]

You didn't understand my story.

I am talking about viewing checkboxes as a checkboxes in Pivot Table View.
I can't see checkboxes in Pivot Table view (Instead of Checkboxes I see the value of the checkboxes (True/False), But in datasheet view I can see the checkboxes.


I need help here

Thanks

 

[llkhoutx]

Table is Pivot Table View is the operative word. Tables are for raw data and seldom used to display data.

I don't think that you can display a checkbox when displaying a table; there's no table property for it. If you display your pivot data in a form or report, you can display a checkbox which is merely a control with a control source.

 

[Chipcom]

I don't agree with you

So why when you view with datasheet view you can see the checkbox?
I don't agree with you