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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text Box bottom alignment

Status
Not open for further replies.

TJones8

Technical User
Apr 16, 2002
77
GB
Hi, i have a report that print off various item descriptions and costs for a quote.
i would like to be able to make the cost in-line with the last line of the item description line.
EG :-

<item1 Description> <item1 cost>

<item 2 longer
description> <item2 cost>

And so on...
I cannot figure out a way to do this...whatever i do, it seems to stick in-line with the top or a set offset from the top.
if at first you don't succeed, get a 10lb lump hammer
 
You might try merging the fields on the report. Create an unbound text box and in the control source property for the text box, use this expression:

=[item1 Description] & &quot; &quot; & [item1 cost]

and

=[item 2 longer description] & &quot; &quot; & [item2 cost]

Where the information between the brackets are the field names that you want to merge.

This wont keep the information in columns if thats the way you have it, rather in a paragraph style.
 
Thx for that but, unfortunatly, it does have to be kept in seperate columns.
Damn users and their stupid requirements if at first you don't succeed, get a 10lb lump hammer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top