Re: How to Make my report show only complete fields

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

I do not have yes/no boxes but I have about 30 text fiels with labels, and
some of them are blank. How can I avoid printing labels for empty fields in
the report. I have already changed my labels to text field, Yes for
CanShrink. It worked for 2 fields, but not for others. Any easier way, please?

"Marshall Barton" wrote:

> DavPet wrote:
>
> >I have report that I created using the Report Wizard. It shows all of the
> >fields from my table, just like I want it to. When a record in my table
> >contains all completed data, I want all of the fields to show. Records in
> >my table contain completed fields AND incomplete fields, I want the report
> >to show only the completed fields, like this:
> >Record1
> > Field_A
> > Field_C
> >Record2
> > Field_C
> >Record3
> > Field_B
> >
> >Right now I see blank lines where the field are incomplete.
> >
> >The table contains a Yes/No box to indicate if it's related field is
> >complete. Those are the ones I want to see in report without blank lines
> >where the incompleted ones would have shown.
>
>
> Use an expression instead of just the field name in the text
> boxes:
>
> =IIf([yesnofieldA], [FieldA], Null)
>
> and set both the text boxes' and the Detail section's
> CanShrink property to Yes.
>
> --
> Marsh
> MVP [MS Access]
>
.

Relevant Pages

  • Re: room chart problems
    ... I would probably create an unbound report with text boxes or labels ... then setup a join query how do i then put the occupants of each room ...
    (microsoft.public.access.reports)
  • Re: Referencing objects in option group
    ... I also like your approach to additional check boxes. ... >provide the data for the report. ... >>>BlankI have a series of check boxes and associated labels within an ... >>> cbxLabel.caption = myText ...
    (microsoft.public.access.reports)
  • Re: room chart problems
    ... then setup a join query how do i then put the occupants of each room ... in their "very specifically layout" rooms on my report? ... Am I right in now thinking that the boxes on the report are, in effect, ... labels you could achieve everything you seem to want ...
    (microsoft.public.access.reports)
  • Re: combine last name and first name
    ... the report view shows the data in boxes, ... Went to Design view and selected both the labels and data, ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How to Make my report show only complete fields
    ... >I have report that I created using the Report Wizard. ... >my table contain completed fields AND incomplete fields, ... >Right now I see blank lines where the field are incomplete. ... and set both the text boxes' and the Detail section's ...
    (microsoft.public.access.reports)