How can I design a report as a business directory ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
comments inline.

Br. Dismas SFO said:
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?
Click to expand...

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"?
Click to expand...

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?
Click to expand...

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