R Rick Brandt Apr 18, 2008 #2 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.
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.
E Evi Apr 23, 2008 #3 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
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
