Removing white space around a field in a report

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

Guest

Creating an envelope template in reports. Is there a wizard or built-in
template I can use? I know there is a label wizard, but what about an
envelope wizard?

Not finding a wizard, i decided to create an envelope template from scratch.
Problem: white space to the left and right of my fields, i.e., if my
firstname field is 20 characters in length, but I only have a 10-char name,
the printout keeps the extra 10 spaces. Is there a way, short of writing a
formula for each field, to remove excess horizontal space between fields?
 
Creating an envelope template in reports. Is there a wizard or built-in
template I can use? I know there is a label wizard, but what about an
envelope wizard?

Not finding a wizard, i decided to create an envelope template from scratch.
Problem: white space to the left and right of my fields, i.e., if my
firstname field is 20 characters in length, but I only have a 10-char name,
the printout keeps the extra 10 spaces. Is there a way, short of writing a
formula for each field, to remove excess horizontal space between fields?
Click to expand...

Instead of 2 controls for First Name and Last Name, use one UNBOUND
control. Set it's controls source to:
=[FirstName] & " " & [LastName]

Do something similar for the City and State line as well:
=[City] & ", " & [State] & " " & [ZipCode]
 
Back
Top