I created a report, which is a letter to our employees, that automatically
populates the names of the employees in the salutation section of the letter.
The names being populated is based on a query. The question is, how can I
have a comma, which is a label in the report, move based on the length of the
name?

For example: The report is set up this way: "Dear ,". When I run
the query to populate the names, the output goes like this: "Dear David
Johnson ,". The comma stays in place while having the employee name field
sized to the longest name on the list. The bottom line is, I'd like for the
comma to automatically adjust its position so that the output would always be
something like this: "Dear David Johnson,".

The employee name field has a property set to "yes" for "Can Grow", but that
still doesn't fix the comma placement problem I'm having.

I hope my explanation made sense. Any suggestion you can provide will be
greatly appreciated.

Thanks,
Nyla

Add the comma to the name in a query, and use that query as the report's
RecordSource.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Nyla K" <(E-Mail Removed)> wrote in message
news:7989A7AA-0011-445B-B3A4-(E-Mail Removed)...
>I created a report, which is a letter to our employees, that automatically
> populates the names of the employees in the salutation section of the
> letter.
> The names being populated is based on a query. The question is, how can I
> have a comma, which is a label in the report, move based on the length of
> the
> name?
>
> For example: The report is set up this way: "Dear ,". When I
> run
> the query to populate the names, the output goes like this: "Dear David
> Johnson ,". The comma stays in place while having the employee name
> field
> sized to the longest name on the list. The bottom line is, I'd like for
> the
> comma to automatically adjust its position so that the output would always
> be
> something like this: "Dear David Johnson,".
>
> The employee name field has a property set to "yes" for "Can Grow", but
> that
> still doesn't fix the comma placement problem I'm having.
>
> I hope my explanation made sense. Any suggestion you can provide will be
> greatly appreciated.
>
> Thanks,
> Nyla

On Jul 6, 6:46 pm, Nyla K <N...@discussions.microsoft.com> wrote:
> I created a report, which is a letter to our employees, that automatically
> populates the names of the employees in the salutation section of the letter.
> The names being populated is based on a query. The question is, how can I
> have a comma, which is a label in the report, move based on the length of the
> name?
>
> For example: The report is set up this way: "Dear ,". When I run
> the query to populate the names, the output goes like this: "Dear David
> Johnson ,". The comma stays in place while having the employee name field
> sized to the longest name on the list. The bottom line is, I'd like for the
> comma to automatically adjust its position so that the output would always be
> something like this: "Dear David Johnson,".
>
> The employee name field has a property set to "yes" for "Can Grow", but that
> still doesn't fix the comma placement problem I'm having.
>
> I hope my explanation made sense. Any suggestion you can provide will be
> greatly appreciated.
>
> Thanks,
> Nyla

With Excel and Access it is very easy to make a text like you want:
Ex: =[FirstName} & " " & [LastName] & ", " gives Paul Johnsen,

Hope it helps!

Hans Kristian Eide