Letter in Reports

[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

 

[RonaldoOneNil]

Create 1 new field with a control source of
=F_name & " " & L_name

 

[Stefan Hoffmann]

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?

Use =([F_Name] + " ") & [L_Name] as ControlSource with only one TextBox.



mfG
--> stefan <--

 

[TedMi]

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

 

[Klatuu]

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.

 

[LG]

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?

 

[John W. Vinson]

How do I get a space between the first name and last name?

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?

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.

 

[LG]

How would I add a , after the name?

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.




.