Unanswered: Empty Spaces and Blank Lines and a long IIF
I've seen this issue covered to some extent in previous posts, but here's my "special case" sob story:
Sometimes, address fields are blank (like no country information) and I want to move up the next field on the report so I don't print blank lines. I've concatenated my address fields, checked them for nulls and it doesn't work. I thought it was because my 'blank' fields are actually comprised of spaces (38 spaces), so I tried trimming them with Trim and Trim$, but that didn't work either (see code sample below). I tried putting in 38 spaces between quote marks, but that didn't work either - I may have miscounted as my thumb got very tired...
I'm running Access 2002 on Win98. Yes, I've read Q287685 Concatenating Fields in Text Box to Remove Blank Lines.
Here's my code with the trim$ functions intact (hope it shows okay):
Thanks for your speedy reply, but the CanShrink is already set to Yes and yet the field does not shrink. FYI - there is no label associated with this concatenated field.
Any more ideas, let me know...I did try an IsEmpty expression, but that didn't work, either.