text field cannot grow

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help because I have a problem in using the can grow property for a
text box. I am using Access 2000 (9.0.4402 SR-1). I have created a text box
in the detail area of a report. The content of the textbox is a formula that
concatenates several strings. Each string is converted from a numeric field
if that field is not zero.

I found that the can grow and can shrink options of the text field have been
turned to Yes. The textbox is put in the detail area of the report and the
can grow and can shrink options of the detail area is also set to Yes.

I have tried to extend the width of the text field and found that the second
value (which is supposed to be displayed with the text field) appears.
However, when I run the same report with same data again with the width of
the text field changed back to normal, the value disappear again.

So, I think the formula works but there may be problems of the textbox that
makes the can grow option does not work normally.

Thanks for your help.

Rgs,
John
 
The CanGrow property refers to growing vertically down the
page rather than growing to the right on the same line. A
growing control can push the lines underneath it down the
page with out upsetting formatting usually, but one growing
sideways could play a lot of havoc with any controls on the
same line. Can you just make it longer to start with if
there is nothing to the right?
 
Dear Gary,

Thanks for your attention. Unfortunately, there is an amount field on
the right hand side. Moreover, the report is to print on a pre-printed form
and there are pre-printed lines that partition the space of the detail area.

So, I really need to make that field wrap to the next line properly and
automatically. Please help me to solve this problem.

Thank you for your attention.

Rgs,
John
 
Set the text box size to the maximum that your "pre-printed form" will
allow. Then, set its Can Grow property to No.

Stephen Lebans may have a solution at his site that would change the font
size to make the text fit the text box. Search at www.lebans.com.
 
Dear Duane Hookom,

I will try this out later on. But is that mean my problem is something
out of the scope of Access? For example, can grow does not support formula
or anything else?

I will try the font size solution out and I just hope that the font size
eventually will not become too small because
1.) the report is actually an invoice to be sent outside. It is
using a dot-matrix printer to print on a 4-ply pre-printed form. So, there
is limitation on font size because dot-matrix cannot print text with small
font size or may print it very very slow.
2.) You may also understand that the report will become very strange
/ odd if there are some fields that shrink to a very small font size. In
particular, these text is not some "not so important text" such as "Note".
Actually, they are discount percent placed on the left size of amount and
they are important in caluclating the amount.

I will try this out very soon and hope that the outcome is acceptable to
end-users. But if end-users do not accept, please help me to solve this
problem in another way.

Thank you very much for your help.

Rgs,
John
 
Maybe I misunderstand you needs but I assume you have a rectangular space on
your report that you need to place the value from your expression. Why not
just make the text box that exact size and don't allow it to grow?
 
Dear Duane Hookom,

As the field contains discount value of the transaction, it must show all
discount percent values for it. For example, there is a trade discount of
12%, promotion discount 15% and a rebat discount 13%, and it is a transaction
for 5 items with unit price $20. Then the report will show 5 ..... 20 .....
Less 12%, 15%, 13% and finally the amount 65.1 (which is 100 X .88 X .85 X
..87). If the textbox cannot grow, these percentages as well as the setting
cannot be shown. The transaction will become invalid.

When end-users told me about this problem, they said that the report
should be able to wrap the discount value to the next line automatically.
That is :

Less 12%, 15%,
13%

If the space is enough (such as the discount is smaller), it can be
displayed in one line like this :

Less 8%, 5%, 3%

So, I really need to fix this problem. Please help.

Thank you for your attention.

Rgs,
John
 
Are you suggesting that a long string of text will not line wrap in a text
box? If so, what happens if you create the text in the report's query?

What is a typical value that is in the text box?
 
Dear Duane Hookom,

I will try this out after the holiday.

Thanks for your suggestion. Happy new year.

Rgs,
John
 
Dear Duane Hookom,

Happy New Year. I have just come back and checked the typical value.
Usually, the text field will be "Less 20%, 15% & .25%". In other words, the
..25% should be wraped to the next line. Some others will be 10%, 0% and 5%.
In addition, the discount setting may be affected by the customer,
transaction type and the business decision.

However, if I hard-code the position of the percentage, the 10, 0, 5 case
will be odd because 0 is not gonna to display and the 5% will not wrap.

Moreover, actually the system provides 5 fields for different type of
discount.

So, the best solution is to concatenate all discounts (value <> 0) and
then let Access to wrap the text field for me.

Thanks for your attention.

Rgs,
John

Thanks for your attention.

Rgs,
John
 
None of this makes much sense to me. I don't know what you might mean by "if
I hard-code the position of the percentage".

Are you dealing with one text box or more?
 
Dear Duane Hookom,

Thanks for your reply. I am dealing with 1 textbox only. And as stated
in last email, I hope that I can convert 5 numeric value to 5 strings,
concatenate these values and put into the text box if that value <> 0. And
finally Access will help me to wrap the text if it is longer than the space
assigned to this field in the pre-printed form.

And in your last email, you have asked "What is a typical value that is
in the text box", so I just list out some of these data for you. Is that what
you mean about typical value?

I hope this can let you have a better understanding.

Thank you for your attention.

Rgs,
John
 
So, what you are saying is a value in the text box of "Less 20%, 15% & .25%"
truncates to something like:
+--------------------------+
| Less 20%, 15% & |
| |
+--------------------------+
and not like
+--------------------------+
|Less 20%, 15% & |
|.25% |
+--------------------------+
where the .25% wraps to the next line in the text box.
 
Dear Duane Hookom,

I am sorry that I cannot see the last post for my issue. Indeed, the
system only list 9 post. So, I cannot read even my last post in the system.

Would you please send me your latest reply to my email address? It is :

(e-mail address removed)

Moreover, I found that there are other users who has more than 9 posts.
But why is it that the system does not show my post after there were 9 posts?

Rgs,
John
 
Back
Top