Skip records where a field is blank

[Guest]

Hi,
Please help, I want the records in a report where a field is empty (null) to
skip and not shown.
Do you know how it is done?

Thanks
GL

 

[Ken Snell \(MVP\)]

Add a criterion expression to the query that is the report's RecordSource
that omits records where that field has a Null value.

 

[Guest]

The best solution is Ken suggestion, to remove the Null rows using the Record
Source of the report.

Another option will be, to set the Can Shrink property of the Text boxes and
the Section where the Text Boxes are located in to Yes.
Just another approach that can be handy sometimes

 

[fredg]

Hi,
Please help, I want the records in a report where a field is empty (null) to
skip and not shown.
Do you know how it is done?

Thanks
GL

One way is to code the Detail Section Format event:

Me.PrintSection = Not IsNull([FieldName])
Me.MoveLayout = Not IsNull([FieldName])

But why are any of these records in the report record source in the
first place?

 

[Guest]

Thank you all
The records contain information about products, in some of those products
the cost field is empty because the price is not fixed yet so I dont't want
tthose records to show in report.
I have also tried in the format event th code
Me.Detail.Visible = Not IsNull(Me.TxtCost)
and it works.
Do you know which one of the suggested methods wil give faster report?

GL

Hi,
Please help, I want the records in a report where a field is empty (null) to
skip and not shown.
Do you know how it is done?

Thanks
GL

One way is to code the Detail Section Format event:

Me.PrintSection = Not IsNull([FieldName])
Me.MoveLayout = Not IsNull([FieldName])

But why are any of these records in the report record source in the
first place?

 

[John Spencer]

Without testing and without knowing the number of records involved I can
only say that in most cases using a query with criteria as the source will
give you the best results in terms of speed. Also, if you decide to change
which records are being printed in the report then the query is the easiest
to modify.

Thank you all
The records contain information about products, in some of those products
the cost field is empty because the price is not fixed yet so I dont't
want
tthose records to show in report.
I have also tried in the format event th code
Me.Detail.Visible = Not IsNull(Me.TxtCost)
and it works.
Do you know which one of the suggested methods wil give faster report?

GL

Hi,
Please help, I want the records in a report where a field is empty
(null) to
skip and not shown.
Do you know how it is done?

Thanks
GL

One way is to code the Detail Section Format event:

Me.PrintSection = Not IsNull([FieldName])
Me.MoveLayout = Not IsNull([FieldName])

But why are any of these records in the report record source in the
first place?