Help with a Text box Align

[istone]

Hi everyone,
I need help on the following issue.
I have 2 text boxes and a label in a report linked to a query. All together they form a sentence like this:

1001 basis point on Total of $415

1001 is the first linked text box, basis point on Total of is a label and $415 is the other text box.

The issue I have is the space between the first text box and the label. when the box = 1001 the space is fine, when it equals 1 or 2 or 3 digits it leaves more space. I tried using can grow and can shrink in the box properties but it did not work. Any ideas?


1001 basis point on Total of $415
3 basis point on Total of $5487
10 basis point on Total of $87
1.5 basis point on Total of $87


Thanks in advance

 

[istone]

Problem Sovled. If anyone needs to know the answer, I created one text box with this code:

=[BP QTR Number] & " " & "Basis Points on total assets of" & " " & [Assests]