Letter in Reports

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

Thank you for all the assistance in building a report as my letter instead of
a mail merge. My dilemma is the space in the fields. Does anyone have any
ideas for example I have F_name L_name in 2 different fields but right next
to each other. I spaced them out to provide enough room just incase the
first name is long, i used specified yes in the can grow and can shrink in
the properties but, still find there is too much space between the names.
Any other suggestions?
Thank you
 
hi,
Thank you for all the assistance in building a report as my letter instead of
a mail merge. My dilemma is the space in the fields. Does anyone have any
ideas for example I have F_name L_name in 2 different fields but right next
to each other. I spaced them out to provide enough room just incase the
first name is long, i used specified yes in the can grow and can shrink in
the properties but, still find there is too much space between the names.
Any other suggestions?
Click to expand...
Use =([F_Name] + " ") & [L_Name] as ControlSource with only one TextBox.



mfG
--> stefan <--
 
Instead of two fields for F_name and L_name, create just one field whose
data source is:
=F_name & " " & L_name

That's assuming tha F_name and L_name are the field names used in the query
which is the data source of your report.
-TedMi
 
Use Stefan's suggestion using the + rather than the &.
Although & is syntacicallay correct, the advantage of the + is that if
either F_Name or L_Name is null, it will not create the space between them.
 
How do I get a space between the first name and last name? Also. to put
City, state and zip code together how do I add the space and , appropriately?
 
How do I get a space between the first name and last name?
Click to expand...

Ummmm...

By following Ted's instructions. Did you try it?
Also. to put
City, state and zip code together how do I add the space and , appropriately?
Click to expand...

A calculated field in the query

CityStateZip: [City] & (" " + [State]) & (" " + [Zipcode])

will work and will not put in extra spaces if one of the fields is null.
 
How would I add a , after the name?

Klatuu said:
Use Stefan's suggestion using the + rather than the &.
Although & is syntacicallay correct, the advantage of the + is that if
either F_Name or L_Name is null, it will not create the space between them.




.
Click to expand...
 
Back
Top