Showing or hiding fields in an Access report
I have a db created for managing employee records. I would like to build a label report that shows or hides different fields on the label depending if a field has a value. The fields are Office, home address, city, state, and zip. If the member has an office location then i would like to hide the address, city, state, and zip. If the member does not have an office location then i would like to see address, city, state, and zip.
Software/Hardware used:
Software/Hardware used:
ASKED:
October 23, 2010 10:08 PM
UPDATED:
October 30, 2010 5:57 AM
Answer Wiki:
U may try this code, assuming this is in the report detail, this code would be in the Detail section's format event, for example, if u try to hide null field then :
if isnull(me!fieldname) then
me!fieldname.visible = false
else
me!fieldname.visible = true
endif
Just change here according to ur field name !
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
