Spacing Text on Report

  • Thread starter Thread starter Novice2000
  • Start date Start date
N

Novice2000

Hello,

I have created a report which is an envelope. The fields that are causing me
problems are the Salutation, First_Name and Last_Name of the recipient.
Since these are saved in separate fields, it is difficult to place the fields
on the report so that there isn't a gap between the first and last name.

ANy ideas as to how to correct this other than create a new combined field?
 
Combine them in a calculated field in the underlying query or Combine them
in a control on the report. If you do the concatenation (combine to text
strings) on the report, you must make sure the control has a different name
then the fields you are using.

Add a New Control top the report
Name: FullName
Control Source: = [First_name] & " " & [Last_Name]


In query design view (query grid) in a blank field "cell" add
FullName: [First_name] & " " & [Last_Name]
And then use FullName.

DO NOT add a new field to your table to contain this value.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Thanks John. You were right I was about to add a field to the table LOl -
mindreader.

John Spencer said:
Combine them in a calculated field in the underlying query or Combine them
in a control on the report. If you do the concatenation (combine to text
strings) on the report, you must make sure the control has a different name
then the fields you are using.

Add a New Control top the report
Name: FullName
Control Source: = [First_name] & " " & [Last_Name]


In query design view (query grid) in a blank field "cell" add
FullName: [First_name] & " " & [Last_Name]
And then use FullName.

DO NOT add a new field to your table to contain this value.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Novice2000 said:
Hello,

I have created a report which is an envelope. The fields that are causing
me
problems are the Salutation, First_Name and Last_Name of the recipient.
Since these are saved in separate fields, it is difficult to place the
fields
on the report so that there isn't a gap between the first and last name.

ANy ideas as to how to correct this other than create a new combined
field?
Click to expand...
Click to expand...
 
John, When you say to add a new control to the top of the report, which
control do I add? I haven't done a lot with various controls, so sorry if
this is really basic. I see the box of controls at the top of the window,
but don't know which one to add in order to fill in the name and control
source shown below. Thanks.

KK

John Spencer said:
Combine them in a calculated field in the underlying query or Combine them
in a control on the report. If you do the concatenation (combine to text
strings) on the report, you must make sure the control has a different name
then the fields you are using.

Add a New Control top the report
Name: FullName
Control Source: = [First_name] & " " & [Last_Name]


In query design view (query grid) in a blank field "cell" add
FullName: [First_name] & " " & [Last_Name]
And then use FullName.

DO NOT add a new field to your table to contain this value.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Novice2000 said:
Hello,

I have created a report which is an envelope. The fields that are causing
me
problems are the Salutation, First_Name and Last_Name of the recipient.
Since these are saved in separate fields, it is difficult to place the
fields
on the report so that there isn't a gap between the first and last name.

ANy ideas as to how to correct this other than create a new combined
field?
Click to expand...
Click to expand...
 
A text box control should be used.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

John, When you say to add a new control to the top of the report, which
control do I add? I haven't done a lot with various controls, so sorry if
this is really basic. I see the box of controls at the top of the window,
but don't know which one to add in order to fill in the name and control
source shown below. Thanks.

KK

John Spencer said:
Combine them in a calculated field in the underlying query or Combine them
in a control on the report. If you do the concatenation (combine to text
strings) on the report, you must make sure the control has a different name
then the fields you are using.

Add a New Control top the report
Name: FullName
Control Source: = [First_name] & " " & [Last_Name]


In query design view (query grid) in a blank field "cell" add
FullName: [First_name] & " " & [Last_Name]
And then use FullName.

DO NOT add a new field to your table to contain this value.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Novice2000 said:
Hello,

I have created a report which is an envelope. The fields that are causing
me
problems are the Salutation, First_Name and Last_Name of the recipient.
Since these are saved in separate fields, it is difficult to place the
fields
on the report so that there isn't a gap between the first and last name.

ANy ideas as to how to correct this other than create a new combined
field?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top