Report.HasData Property

Access Developer Reference

You can use the HasData property to determine if a report is bound to an empty recordset. Read/write Long.

Syntax

expression.HasData

expression   A variable that represents a Report object.

Remarks

The HasData property is set by Microsoft Access. The value of this property can be read only while printing or while in Print Preview.

The HasData property uses the following settings.

Value Description
–1 The object has data.
0 The object doesn't have data.
1 The object is unbound.

You can use this property to determine whether to hide a subreport that has no data. For example, the following expression hides the subreport control when its report has no data.

Visual Basic for Applications
  Me!SubReportControl.Visible = Me!SubReportControl.Report.HasData

See Also