Limiting Field Display in Reports

  • Thread starter Thread starter Terry Thornton
  • Start date Start date
T

Terry Thornton

How can I set a field in a report to display only when the
field values for the record are between a designated range
of values. I want to display all records but limit when
this field displays. The field contains data value codes
that are no longer used, but have historical value so I am
unable to modify the records.
 
Terry said:
How can I set a field in a report to display only when the
field values for the record are between a designated range
of values. I want to display all records but limit when
this field displays. The field contains data value codes
that are no longer used, but have historical value so I am
unable to modify the records.
Click to expand...


Place some code in the detail section's Format event:

If Me.datetextbox >= rangestart _
And Me.datetextbox <= rangeend Then
Me.codetextbox.Visible = True
Else
Me.codetextbox.Visible = False
End If
 
Back
Top