Is it possible to put a TAB chr() in a string expression?

[adrift]

The chr(13) & chr(10) has been a life saver for carriage returns, is there a similar method for using a tab in a string expression. I'm concanating two strings but the first string has variable length, but I'd still like the second string to match up in alignment. IE:

 

[StewartGW]

Use the VB constant, vbTab, in order to include a tag in a concantenated string.

Example:

strData = 'The temperature is : " & vbTab & "65 degrees"

 

[adrift]

I've tried both that and chr(9) and it displays the dreaded little box character rather than the expected tab.

 

[PaulF]

Why concatenate? If you want them to line up, why not just leave them in 2 fields and use 2 TextBoxes, then Right Justify the 1st TextBox, and Left Justify the 2nd TextBox.

PaulF

 

[adrift]

Because I'm concatenating in VBA based on a criteria search. It is necessary to do it this way.

 

[PaulF]

try using spaces
In this example 20 would be the maximum length of Field1

Field1 & Space(20 - Len(Field1)) & Field2


PaulF

 

[adrift]

that's the ticket.. thanks..

by the way, now that you're here.. can you recommend any free rich text format controls?

I was using the microsoft one but it doesn't allow print preview..

 

[PaulF]

sorry, can't help you on that one

PaulF