Re: Displaying Yes fields but not NO

Tech-Archive recommends: Speed Up your PC by fixing your registry

Althekid wrote:
Thank you for your prompt reply.
Forgive me for being a bit dim! but could you please guide me as to
where i need to enter this code?

To clarify... Do you want records with the value "No" to be filtered out or do
you want to just hide this field when it is "No"?

For the former set the criteria of your report's query so it only includes the
"Yes" rows by using True as the criteria for that column.

For the latter just use a TextBox for your field on the report with a
ControlSource of...

IIf([FieldName]=0, "", "Yes")

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


.

Relevant Pages

  • Re: Record Lookup
    ... Dim SelectedRows() As DataRow ... The select method returns all rows matching the criteria. ... primary key in the table to the field that I wanted to use for the search ... Dim drSelectedRecord As DataRow ...
    (microsoft.public.dotnet.languages.vb)
  • =?windows-1252?Q?Re=3A_Dlookup=85DoCmd=2EOpenForm=2E=2Eor=3F?=
    ... SQL and looks for the recordset matching the criteria in the "search" ... Dim rs As DAO.Recordset ... Dim strDialog As String ... MsgBox "Missing Date, Shift, or Area! ...
    (microsoft.public.access.formscoding)
  • Re: Conditional Copy/Paste
    ... Dim ws As Worksheet ... 'Add the heading to the criteria area ... 'transfer data to individual City worksheets ... Set cityListRange = Sheets.Range.CurrentRegion ...
    (microsoft.public.excel.misc)
  • Re: Delete a row with a certain phrase?
    ... Dim rTable As Range ... 'Get the criteria in the form of text or number. ... If vCriteria = "False" Then Exit Sub ... If lCol = 0 Then Exit Sub ...
    (microsoft.public.excel.programming)
  • Re: Macro to copy files
    ... If that does not make sense here are a few examples, the criteria is to copy ... The macro seems to work fine until it reaches the third document in the ... 'This example copy all files between certain dates from FromPath to ToPath. ... Dim FromPath As String ...
    (microsoft.public.excel.programming)