KylePutzier

Aligning columns and variable width fonts.

Discussion created by KylePutzier on May 28, 2014
Latest reply on May 28, 2014 by KylePutzier

I am using a simple Custom Dialog to quickly display various record totals. The problem is that the dialog uses a variable width font that I cannot control. It makes using the text formatting tools ineffective as the number of padding spaces varies.

Is there a way of padding the dollar figures so that they right justify more evenly as thier Lenght() changes?

My first thought is something like PaddingSpaces = (15 - Lenght(DollarValue)) * 1.5

 

Sample of existing output below.

 

 

Number of Sales Orders: 19

 

Unbilled: $ 47,399.35

Partially Billed: $ 56,560.16

_________________________________

Active Sales: $ 103,959.51

Inventory Orders: $ 0.00

_________________________________

All Sales: $ 103,959.51

 

 

 

Desired output like this.

 

 

Number of Sales Orders: 19

 

Unbilled: $ 47,399.35

Partially Billed: $ 56,560.16

__________________________________

Active Sales: $ 103,959.51

Inventory Orders: $ 0.00

__________________________________

All Sales: $ 103,959.51

 

 

( I even had to fiddle with this to attempt to show an example. Your view may still not right align)

Outcomes