Thank you for your post.
Here is one option for your calculation:
Left ($StatText & $CurrentOrigin & " "; 20) & Right ("
That is, we put together the $StatText and $CurrentOrigin variables along with 20 spaces. We use the Left function to use the first 20 characters. Since spaces are added to the end, they are removed. In all cases, you are left with a 20-character string.
Now, the Sales is a number/currency field, so we want that right justified. So, we use the opposite logic. That is, we takes 10 spaces and a
if you are on a Win machine ( I don't know on a Mac ) copy this text and put it in the calculation for the custom message:
& ¶ &
Note that the space between words isn't a space but a TAB; you can type that char with Ctrl + TAB.
On a Mac you may need to store the tab in a global field by copying and pasting.
Thanks, a combination of both options worked
Spaces by themself did not because of the spacing in custom dialogue boxes is not equal but tabs by themself would not work either because of the variation in length of $CurrentObject
$StatText & Left ($CurrentOrigin & " " ; 50)& " " & $TotalSales & "¶"
This calculation does contain the tabs as described by raybaudi even though they show as spaces on this post