How can I design a report as a business directory ?

[Guest]

I have a query of pertinent data, I want to format 4 or 5 columns accross
Portrait view using 6 and 8 font, bold and Italic.
I have address1, address2, city, state, etc.
How can I get address2 to "shrink" or "be invisible" if it doesn't apply?
How can I format "names" and "City" to accomodate long and short names with
out a large space between LastName - FirstName and "City" - "State"?
I have "can shrink" - yes, "can grow" - no
Any suggestions on placing the "Handicapped" symbol?

 

[tina]

comments inline.

I have a query of pertinent data, I want to format 4 or 5 columns accross
Portrait view using 6 and 8 font, bold and Italic.
I have address1, address2, city, state, etc.
How can I get address2 to "shrink" or "be invisible" if it doesn't apply?

set the control's CanGrow and CanShrink properties to Yes. ditto those
property settings in the report Section that the control is in.

How can I format "names" and "City" to accomodate long and short names with
out a large space between LastName - FirstName and "City" - "State"?

instead of textboxes bound to the fields, use unbound textboxes with
concatenated values. for instance, for first and last names, remove the
second textbox. rename the first textbox, if necessary, so that it does not
have the same name as either the first or last name field. set the
ControlSource property of the textbox to

=([FirstNameField] + " ") & [LastNameField]

the above syntax also properly formats records where you might have data in
the last name field only.

if you have City and State data for every record, without fail, you can use
simpler syntax for the ControlSource of the unbound "city/state" textbox, as

=[City] & ", " & [State"

I have "can shrink" - yes, "can grow" - no
Any suggestions on placing the "Handicapped" symbol?

sorry, don't understand what you're referring to.

 

[Guest]

Look for a font set that has the Handicapped symbol in it. You may need to
purchse this.