YES/NO Field on Report

[tpearo]

I have a field on a report that is a YES/NO Checkbox from a data entry form. On the form there are three options. For example if the answer is yes of course I want Yes to show up on the report. If the answer is No then I want No to show up on the report. But..... If the answer in left blank I want a blank space or no answer to show up on the report.

My problem is that if the answer is left blank then I get a 0 on my report. How do I get rid of the 0 (Zero) if the answer is left blank?

Any help or ideas are appreciated.

Tp

 

[PHV]

A boolean field don't have a triplestate property like a checkbox control.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[tpearo]

O.K....... That was a good Greek lesson.

Now what does that mean?

Tp

 

[earthandfire]

I think what PHV was saying was that you should investigate the TripleState property of a the CheckBox control.

Basically, the CheckBox will show a tick for True, nothing (ie empty) for False and will be greyed out if its value is Null.

TripleState is on the Data tab of the property window along with the Control Source.

 

[PHV]

Now what does that mean?
That a YesNo field in a table/query is either true or false but neither blank or null.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Reuel]

Here's a bit of help:
for the field named YN, change the control's source from 'YN' to '=iif(YN=0,"",YN)'
If you are in fact using a boolean field, you'll need to make it a triple-state field in your table and make the source something like this: '=iif(isnull(YN),"",YN)