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
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] &
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;_