HasData Property [Access 2003 VBA Language Reference]

  • Article

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

expression.HasData

expression Required. An expression that returns one of the objects in the Applies To list.

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.

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

Note  You can get the value of the HasData property by using a macro or Visual Basic .

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.

Me!SubReportControl.Visible = Me!SubReportControl.Report.HasData

Applies to | Report Object

See Also | NoData Event