Connecting Tech Pros Worldwide Help | Site Map

Help with a Text box Align

Member
 
Join Date: Feb 2007
Location: New York
Posts: 72
#1: May 30 '07
Hi everyone,
I need help on the following issue. I have 2 text boxes and a labelin 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
Member
 
Join Date: Feb 2007
Location: New York
Posts: 72
#2: May 30 '07

re: Help with a Text box Align


Thanks in advance.
In the example you can't see the space because i a m sure how to do it.
Member
 
Join Date: Feb 2007
Location: New York
Posts: 72
#3: May 30 '07

re: Help with a Text box Align


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]
Reply