By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,689 Members | 1,121 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,689 IT Pros & Developers. It's quick & easy.

Help with a Text box Align

P: 72
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
May 30 '07 #1
Share this Question
Share on Google+
2 Replies

P: 72
Thanks in advance.
In the example you can't see the space because i a m sure how to do it.
May 30 '07 #2

P: 72
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]
May 30 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.