Oct 20 2007, 06:41 PM
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
TaskTotal.Top = 0
Oct 21 2007, 09:32 AM
Why can't you concatenate the currency field onto the description field, set the texbox as cangrow, and eliminate the code?
Oct 21 2007, 05:24 PM
I have had success with this:
I think the code should be able to help you.
Oct 21 2007, 08:52 PM
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.
Oct 21 2007, 09:11 PM
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.
Oct 21 2007, 09:26 PM
Sorry about that.
Try this link:
Oct 22 2007, 11:32 PM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here