I have a report that has a description field and a currency field on the same line.
If the .cangrow & .canshrink are active on the Description field, how do I get the currency to display at the bottom of the Description field when it goes into 2 or 3 lines?

This is the code that I've tried:
TaskTotal being the field with the currency and ScopeOfWorkTask being the description field (Memo)

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Detail.Height > TaskTotal.Height Or Len(ScopeOfWorkTask) > 50 Then
TaskTotal.Top = Me.Detail.Height - TaskTotal.Height
Else
TaskTotal.Top = 0
End If

End Sub

Why can't you concatenate the currency field onto the description field, set the texbox as cangrow, and eliminate the code?

Robert Crouser

I have had success with this:

Print Lines

I think the code should be able to help you.

But I need all the currency figures in line with each other. Can you use Decimal Tabs to put it over on the right hand side of the page and all in allignment.

Sorry is the Print Lines a command, as your link doesn't go anywhere and i can't find the command in the Access Help.

Sorry about that.

Try this link:
Print Lines

Th9s may also help:
Vertical Justification