trim in design view

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

Im trying to use trim but it keeps coming up with"entre
parameter value" what does this mean? Also how do you get
rid of spaces from cells that have nothing in them.
Please help.
 
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
 
Back
Top