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

  • Thread starter Thread starter kthomps
  • Start date Start date
kthomps said:
I need to hide the no answers in a Access table - how do I do that?
Click to expand...

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.
 
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
 
Back
Top