Re: displaying message on the report when no data is present

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 02/01/05 

Date: Tue, 01 Feb 2005 17:41:57 -0600

talktobatchu wrote:

>First of all thanks to AlCamp for providing me a solution to an earlier
>problem.
>
>I have generated a report basing on a query which gives me the
>number of cases as the result. Here I'm trying to display the same on the
>report, but what I want to do is, if the number of cases are less than 5, I
>want to display as "not sufficient data" on the report.
>I got it with the help of a unbound text control alongside the textbox with
>the following code:
>= IIF(TotalCases < 5, "Insufficient Data",""
>
>The problem is along with the text, the data is also getting displayed and
>what can be done to stop displaying the data when text is displayed
>satisfying the condition.

Add a line of code to the Format event of the section
containing the total cases text box:

        Me.TotalCases.Visible = (Me.TotalCases >= 5) 

-- 
Marsh
MVP [MS Access]

Relevant Pages

  • displaying message on the report when no data is present
    ... I have generated a report basing on a query which gives me the ... want to display as "not sufficient data" on the report. ...
    (microsoft.public.access.reports)
  • Re: DB Result Wizard Error
    ... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)
  • RE: Just starting to design a form (or is it a query?)
    ... A Form is used to display the data and allow ... A query can be the record source for a form. ... that match an ID in the Assessment table. ... Now, assuming this is the case, what you need is a form with a sub form. ...
    (microsoft.public.access.gettingstarted)
  • Re: database lookup
    ... the query on the subsequent page, and display the "drill down" data. ... The thing with PHP and MySQL is that you need the user to do an action ... I tried to state that I have the database designed and implemented but I ...
    (alt.php)
  • Re: how to show two rows in an unbound continuous form
    ... Thanks a lot for your prompt response.Actually i thought of using crosstab ... I have created a crosstab query on the table i gave you earlier.The first ... have bound the form's controlsource also,of course). ... clue how to display the second row to show another leave period(01-05-2009 to ...
    (microsoft.public.access.formscoding)