CAN SHRINK doesn't seem to work for text with controls?

[fivespeedv8]

Hi,

I have a simple car club membership database and I want to print a
roster with the names, adresses, phone numbers, email address,
and role of the members and their associate members (associate
member info is a PART of the member record in the table)

My problem is that if there IS NO associate member in a
particular member record, I still get BLANK LINES for each of
the associate member fields in the report. I am using
the CAN SHRINK property, but the blanks persist. I am
not using any labels for these text fields in the report.

The layout for the assocate member portion of the report
is as follows:


John C. Smith
Member at Large
123 Main st.
Baltimore, MD 21221

(301) 555-1234 (301) 555-5678 ext 4321


I am using CONTROLS to compress the NAME info and the
City, State, and postal code, as these are all separate
fields (fixed width) in the database and I don't want it to
appear as:

John C. Smith

Also, the "member role" field is a value list in the database.


Here is the CONTROL info I am using to eliminate the spaces
and accomodate missing info (such as City but no State)
Could these controls be causing the blank lines to appear?


for the NAME:

=[AssociateMemberFirst Name] & " " & [AssociateMemberMiddleInit] &
" "+[AssociateMemberLastName]


For the ADDRESS:

=Trim([AssociateMember City]+", " & [AssociateMember State]+" " & IIf(Len([AssociateMember ZipCode])=9,Left([AssociateMember ZipCode],5)+"-"+Right([AssociateMember ZipCode],4),[AssociateMember ZipCode]))


Phone number: Just using the field identifier and uses an input mask
if a phone number is entered into the DB: \(000") 0"000\-0000" ext "99999;9;_

AssociateMemberHomePhone AssociateMemberAlternatePhone

 

[fivespeedv8]

Um, I keep using the term CONTROLS! I meant
Expressions. Wow. I REALLY need to get away from
this Microsoft stuff.

 

[RichMorrison]

"Can shrink" is sort of an illusion. When you place a textbox control on a report, the height you specify is the minimum. Access will not shrink it below that minimum.

So if you put 4 textboxes for the address detail and a fifth for phone, you will get 5 lines vertical whether filled or blank.

RichM

 

[llkhoutx]

Make the textbox height 0.

Modify the record source to a query, eliminating "null"/empty records.

[This message has been edited by llkhoutx (edited 05-20-2002).]

 

[RichMorrison]

you wrote:
<<
Make the textbox height 0.
Modify the record source to a query, eliminating "null"/empty records.
>>

Yes a textbox can "grow" to print extra lines. I was assuming the report contained several text boxes for address line 1, 2, 3, etc.

RichM