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

From: talktobatchu (talktobatchu_at_discussions.microsoft.com)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 13:11:07 -0800

thanks Marshall for the suggestion, but when I write the piece of code into
the Format section of the textbox of TotalCases, the whole code is being
printed on the report instead of hiding it.

guess there should be some other way to do this.
talktobatchu

"Marshall Barton" wrote:

> 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

  • Re: TextBox with comma formatting
    ... If the user inputs numeric characters simply add them to the TextBox ... but display them in thousands comma format. ... [You might even want to define your own custom clipboard format. ...
    (comp.lang.basic.visual.misc)
  • Re: TextBox (v2.0)
    ... Creator of "Professional Validation And More" at ... > client wishes to have the textbox always display the text in this format - ...
    (microsoft.public.dotnet.framework.aspnet)
  • How To Get A Date To Advance In A TextBox
    ... I have a TextBox that needs to display in a date format and a ... The first question is how to get TextBox1 to display a date format ... The second question is how to advance this date with a CommandButton ...
    (microsoft.public.excel.programming)
  • UserForm including TextBox with date (UK format)
    ... I have database which includes also dates in UK format. ... am able to display everything using UserForm with TextBoxes, ... I am able to change that when I leave the TextBox where is the date ...
    (microsoft.public.excel.programming)
  • Re: Tapble top fusion generator
    ... >increased my monitor format to 1280x1024 and display it on a Mitsubishi ... >using a screen format less than 1280x1024 and the low -resolution LCD ... >Since the poster writing about the character overlap, ... is, when you make one web site viewable, you can render others ...
    (sci.physics.fusion)