Auto Resize

[George]

I am creating a form letter to automatically address all my troops and
include their names per report. What I want to resolve is how to add their
names without any gaps between the fields considering each name and rank is a
different length, is that possible.

So it would look something like below ( Rank, First Name, Last Name, are
fields in my table.

Memorandum For: Rank First Name Last Name

Thanks - George

 

[Marshall Barton]

I am creating a form letter to automatically address all my troops and
include their names per report. What I want to resolve is how to add their
names without any gaps between the fields considering each name and rank is a
different length, is that possible.

So it would look something like below ( Rank, First Name, Last Name, are
fields in my table.

Memorandum For: Rank First Name Last Name

Use a single text box with an expression like:

=Rank & " " & [First Name] & " " [Last Name]

 

[George]

Perfect - Thanks

I am creating a form letter to automatically address all my troops and
include their names per report. What I want to resolve is how to add their
names without any gaps between the fields considering each name and rank is a
different length, is that possible.

So it would look something like below ( Rank, First Name, Last Name, are
fields in my table.

Memorandum For: Rank First Name Last Name

Use a single text box with an expression like:

=Rank & " " & [First Name] & " " [Last Name]

 

[Bipbop]

This is exactly what I want, (just first names and last name), but when I
create a text box in my report (certificate), and enter

=First Names & " " [Last Name]

I receive the error:

You have entered an operand without an operator.

What am I doing wrong?

 

[John Spencer]

If your field names have spaces then you MUST surround them with square
brackets []. Also make sure you have spelled the names correctly and that
the control is NOT named the same as the fields you are using in the
expression.

=[First Names] & " " [Last Name]

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

This is exactly what I want, (just first names and last name), but when I
create a text box in my report (certificate), and enter

=First Names & " " [Last Name]

I receive the error:

You have entered an operand without an operator.

What am I doing wrong?

Use a single text box with an expression like:

=Rank & " " & [First Name] & " " [Last Name]

 

[Bipbop]

Thanks John

This still doesn't work.
The Control (text box) is named: Trainees Name
and I am now using the expression: =[First Names] & " " [Last Name]

I still get the error:
The expression you entered contains an invalid syntax
You may have entered an operand without an operator

If your field names have spaces then you MUST surround them with square
brackets []. Also make sure you have spelled the names correctly and that
the control is NOT named the same as the fields you are using in the
expression.

=[First Names] & " " [Last Name]

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

This is exactly what I want, (just first names and last name), but when I
create a text box in my report (certificate), and enter

=First Names & " " [Last Name]

I receive the error:

You have entered an operand without an operator.

What am I doing wrong?

Use a single text box with an expression like:

=Rank & " " & [First Name] & " " [Last Name]

 

[Rick Brandt]

Thanks John

This still doesn't work.
The Control (text box) is named: Trainees Name
and I am now using the expression: =[First Names] & " " [Last Name]

I still get the error:
The expression you entered contains an invalid syntax
You may have entered an operand without an operator

You need two ampersands.

=[First Names] & " " & [Last Name]

 

[Bipbop]

That's it, thank you Rick

Thanks John

This still doesn't work.
The Control (text box) is named: Trainees Name
and I am now using the expression: =[First Names] & " " [Last Name]

I still get the error:
The expression you entered contains an invalid syntax
You may have entered an operand without an operator

You need two ampersands.

=[First Names] & " " & [Last Name]