text field cannot grow

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?

--
Gary Miller
Sisters, OR



"John" wrote in message
...
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

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


"Gary Miller" wrote:

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?

--
Gary Miller
Sisters, OR



"John" wrote in message
...
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

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.

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Gary Miller" wrote:

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?

--
Gary Miller
Sisters, OR



"John" wrote in message
...
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

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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Gary Miller" wrote:

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?

--
Gary Miller
Sisters, OR



"John" wrote in message
...
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

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?

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Gary Miller" wrote:

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?

--
Gary Miller
Sisters, OR



"John" wrote in message
...
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

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


"Duane Hookom" wrote:

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?

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Gary Miller" wrote:

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?

--
Gary Miller
Sisters, OR



"John" wrote in message
...
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

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?

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Duane Hookom" wrote:

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?

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Gary Miller" wrote:

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?

--
Gary Miller
Sisters, OR



"John" wrote in message
...
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

Dear Duane Hookom,

I will try this out after the holiday.

Thanks for your suggestion. Happy new year.

Rgs,
John





"Duane Hookom" wrote:

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?

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Duane Hookom" wrote:

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?

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Gary Miller" wrote:

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?

--
Gary Miller
Sisters, OR



"John" wrote in message
...
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

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


"Duane Hookom" wrote:

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?

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Duane Hookom" wrote:

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?

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"John" wrote in message
...
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


"Gary Miller" wrote:

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?

--
Gary Miller
Sisters, OR



"John" wrote in message
...
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