Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sizeable text 1

Status
Not open for further replies.

Entrepenueress

Technical User
Aug 12, 2002
16
US
I need to know if it is possible to make text appear on a report right next to each other. I want it to go like this:
LastName, FirstName. I have to make the LastName box big for the big names but don't want the huge space between names on all the others. Can you help? Thanks.
 
Use a calculated value in the query behind the report. It would look similiar to this FullName:[LastName] & ", " & [FirstName]. You may want to add some functionality to check for blank first or last names, but that is essentially it. You would have one text box on the report with its source set to FullName.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top