Align Second Signature to the right

[guat]

Hello,
I have a report that combines a series of text boxes, with text and fields
to create a letter. The letter sometimes has a second signature. My problem
is getting the second signature to be over to the right on the page, like
this:

[Name1] [Name2]
[Title1] [Title2]

Can I use a sort of tab function or assign the second signature to a column
number to get it to be in the same place regardless of the lentgth of
Name/Title 1?
If I concatenate using spaces like this: [Name1] & " " & [Name2] then
name2's position would vary based on the number of characters in name1.
Thanks

 

[RBear3]

I would simply position the Name2 and Title2 fields on the report in the
appropriate position. I'm not sure I understand your question.

Place all the controls where you want them and they will print there.

Perhaps I am missing something.

 

[guat]

RBear3,
Well it's not that easy. I have a series of about 5 text boxes filled with
formulas, of which the last part of where I'm trying to fit this in is as
follows:
....enclosed copy for your records." & Chr(13) & Chr(10) & Chr(13) & Chr(10)
& "I know that I speak for the entire team in saying that we are enthusiastic
about your joining the " & [Department Name] & " department. If you should
have any questions, please do not hesitate to contact me." & Chr(13) &
Chr(10) & Chr(13) & Chr(10) & Chr(13) & Chr(10) & "Sincerely," & Chr(13) &
Chr(10) & Chr(13) & Chr(10) & Chr(13) & Chr(10) & Chr(13) & Chr(10) & [Author
Name1] & Chr(13) & Chr(10) & [Author Title1] & Chr(13) & Chr(10)

So it's not that I can place it on the report, as there are a series of text
boxes set to shrink and grow based on the size of the information in each
field.
Thanks

I would simply position the Name2 and Title2 fields on the report in the
appropriate position. I'm not sure I understand your question.

Place all the controls where you want them and they will print there.

Perhaps I am missing something.

--
Hope that helps!

RBear3
..

Hello,
I have a report that combines a series of text boxes, with text and fields
to create a letter. The letter sometimes has a second signature. My
problem
is getting the second signature to be over to the right on the page, like
this:

[Name1] [Name2]
[Title1] [Title2]

Can I use a sort of tab function or assign the second signature to a
column
number to get it to be in the same place regardless of the lentgth of
Name/Title 1?
If I concatenate using spaces like this: [Name1] & " " & [Name2] then
name2's position would vary based on the number of characters in name1.
Thanks

 

[Melody]

I would break up this whole thing into a few text boxes. So, for eample, you
would have a text box containing "...enclosed copy for your records."
A text box containing "I know that I speak for the entire team in saying
that we are enthusiastic
about your joining the " & [Department Name] & " department. If you should
have any questions, please do not hesitate to contact me."
Another text box containig "Sincerely,"
Another text box containing "[Author Name1] "
A text box underneath containing " [Author Title1]"
Another text box positioned to the right containing ""[Author Name2] "
A text box underneath containing " [Author Title2]"

Note that when you place the text boxes in the report, you don't have to
make them "fit" what you have typed in. So for example, if one of the
paragraphs is three lines, still keep the height of the text box to one line
and set the "Can Grow" and "Can Shrink" properties on each of the text boxes.
Position your text boxes with the amount of space you want between them.
When you run the report, it should open ok. Hope this helps.