user9259

Line up text in value list

Discussion created by user9259 on Jul 9, 2015
Latest reply on Jul 10, 2015 by user9259

I have a script that creates a value list of events. How would you line these fields up into columns? I am using to send an email.

I have tried padding fileds in calculation with spaces and using Courier & Courier New which are mono spaced and no luck..

TextFont(Left(Date&"               ";15) ;"Courier New") &

TextFont(Left(Event # &"                  ";20) ;"Courier New")

 

 

Like this:

7/1/2015           Event 1          Baseball Game

7/10/2015          Event 2          Basketball Game

12/20/2015         Event 3          Soccer Game

 

not like this:

7/1/2015           Event 1          Baseball Game

7/10/2015          Event 2          Basketball Game

12/20/2015         Event 3          Soccer Game


Thank You!

Outcomes