I have the task of fixing a report that I did not create. This report has plenty of fields and sup reports. If the user opens this report and there is no information for a certain text field then the field or text box doesn't show. I would like all fields to show whether or not there is information in the report. Can I please get help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
hidden fields if no data
- Thread starter balistikb
- Start date
PaulBricker
Programmer
What about something in the Format Event that says
If IsNull(Me.FieldName) Then
Me.FieldName = "No Data Available"
Else
End If
Paul
If IsNull(Me.FieldName) Then
Me.FieldName = "No Data Available"
Else
End If
Paul
- Status
Similar threads
- Locked
- Question
