Formatting part of a report

[dkv98446]

I need to create and print a certificate of completion for a seminar and my
user wants the following:

1. Instructor(s) name and title centered.
There may 1 or 2 instructors - I have a format that works with 2
instuctors, but is off center with a single instructor.

2. A solid line ABOVE the insturctor's name, so they can sign the
certificate.

I am stuck on how to determine, if I need 1 or 2 solid lines and how to
center the line and name if I only need one.

Thanks for the help!

 

[fredg]

I need to create and print a certificate of completion for a seminar and my
user wants the following:

1. Instructor(s) name and title centered.
There may 1 or 2 instructors - I have a format that works with 2
instuctors, but is off center with a single instructor.

2. A solid line ABOVE the insturctor's name, so they can sign the
certificate.

I am stuck on how to determine, if I need 1 or 2 solid lines and how to
center the line and name if I only need one.

Thanks for the help!

You can center text by having the report sized to the full width of
the page (less the width of both margins).
Add a text control that extends the full width of the report.
As it's control source you could write:
= [InstructorName1] & ", " & [InstructorName1Title] & IIf(Not
IsNull([InstructorName2]), " " & [InstructorName2] & ", " &
[InstructorName2Title],"")

Set the control's TextAlign property to Center.

Joe Smith TitleA John Brown TitleB

will be centered in the report.

You can do the same thing to display the line.
Place an unbound control where you wish the line to appear.
Size it the same as the above control.
Set it's control source to:
=IIf(IsNull([Instructor2],String(25,"_"),String(50,"_"))

change the 25 and 50 values to whatever size you want.