To remove the space created by controls that have nothing in them, you have a couple of
possibilities.
You can use the CanShrink property of the control so that its height on the report will
shrink to zero if it doesn't contain any data. For this to work, there can't be any other
controls or other objects in line horizontally with this control.
You can concatenate the value of this field with other fields in another control instead
of using a separate control for each field.
For the trim problem, it may be a typo in the line where trim is being used. Another
possibility is a bad Reference. For more information on bad references see:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
