Formatting Text Box in Columns

[EddieN1]

I am filling in a Text Box dynamically from VBA. I want to have three columns aligned even though the Font is TrueType. Is there a way I can insert a column or position number or tab so the text starts or ends at a particular position? If the font were fixed, then it might look like this:



Item_______________Price_______Cost
Blue Widget________10.00_______5.00
Red Widget________125.00______75.00
Super Widget____3,234.23___1.654.32

[AlexHedley]

If you know the position of where you want it to start you could use the len() function to get the length of the field, take that from the above position and that's the number of spaces you need to add between. Just make a loop to add to a spaces variable.

[EddieN1]

Alex, thanks for the suggestion. In the meantime, I tried another technique that worked really well. Instead of one text box with three columns, I created three text boxes. The first had text align left and the next two with text align right. I left the formatting for all three boxes blank so I had to format the two numeric boxes with the Format function and I separated each populated row with a vbCrLf. This worked for me. Thanks again, Eddie