how do I hide the no answers in a yes/no field

I need to hide the no answers in a Access table - how do I do that?

kthomps wrote:
I need to hide the no answers in a Access table - how do I do that?

Normally you would not. Tables are about storage, not presentation.

Use a form or report bound to a query of your table and use criteria in the
query to filter out the NO records.

SELECT *
FROM TableName
WHERE FieldName 0

False or No is actually stored as the number zero.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

You won't be hiding them in your table. You can hide them in your form or
report. No-one has any business looking at your tables!

You haven't given your field name (you may find it easier to follow
instructions if you do this in future posts)

In your query, on which your form is based, you could add this to the query

OnlyYes: IIF([YourYesNoField]=False, "", "Yes")

In your report, you will use code in the On Format Event of the section
containing the control

The code will look like this

If Me.[YourYesNoField]=False Then
Me.[YourYesNoField].Visible = False
Else
Me.[YourYesNoField].Visible = True
End If

Evi




"kthomps" wrote in message
...
I need to hide the no answers in a Access table - how do I do that?