Report only prints the first 48 characters of an 80 character text

[Don S]

I have an 80 character field (Description) which is only showing 48
characters even though there is room to print the whole description.
Somehow, the formatting is causing it to limit the field size to 48 and to
replace the remaining characters with "..." to every record that is over 48
characters. There appears to be plenty of room on the report for the whole
field. I have tried changing the font size, moving the field to a separate
line and stretching it across the page, but without success. This was
originally written in Access 2003, but Access 2007 doesn't fix the problem,
either.
Thanks for any help!

 

[Evi]

Is the Description created by Concatenating a few fields or by manipulating
data with functions? If yes, what is your function ?- the clue may lie in
there.
If not, you could see the real length of your field by using
Len([YourField]) in a query just to check if there are any spaces which were
inadvertantly entered.

What formatting are you using on it? Is it something in the Format line of
the Properties box? If yes, what is your Format line?

You say there is plenty of room. Do you mean that when you put a solid
border around the Control that holds your Description field, the text
doesn't fill it?

Evi

 

[Don S]

Thanks, I see the problem now!

Is the Description created by Concatenating a few fields or by manipulating
data with functions? If yes, what is your function ?- the clue may lie in
there.
If not, you could see the real length of your field by using
Len([YourField]) in a query just to check if there are any spaces which were
inadvertantly entered.

What formatting are you using on it? Is it something in the Format line of
the Properties box? If yes, what is your Format line?

You say there is plenty of room. Do you mean that when you put a solid
border around the Control that holds your Description field, the text
doesn't fill it?

Evi

I have an 80 character field (Description) which is only showing 48
characters even though there is room to print the whole description.
Somehow, the formatting is causing it to limit the field size to 48 and to
replace the remaining characters with "..." to every record that is over 48
characters. There appears to be plenty of room on the report for the whole
field. I have tried changing the font size, moving the field to a separate
line and stretching it across the page, but without success. This was
originally written in Access 2003, but Access 2007 doesn't fix the problem,
either.
Thanks for any help!

 

[Evi]

What was it, Don, I'm dying to know 'cos it's just the sort of inexplicable
stuff that always seems to happen to me.
Evi

Thanks, I see the problem now!

Is the Description created by Concatenating a few fields or by manipulating
data with functions? If yes, what is your function ?- the clue may lie in
there.
If not, you could see the real length of your field by using
Len([YourField]) in a query just to check if there are any spaces which were
inadvertantly entered.

What formatting are you using on it? Is it something in the Format line of
the Properties box? If yes, what is your Format line?

You say there is plenty of room. Do you mean that when you put a solid
border around the Control that holds your Description field, the text
doesn't fill it?

Evi

I have an 80 character field (Description) which is only showing 48
characters even though there is room to print the whole description.
Somehow, the formatting is causing it to limit the field size to 48 and to
replace the remaining characters with "..." to every record that is

over
48

characters. There appears to be plenty of room on the report for the whole
field. I have tried changing the font size, moving the field to a separate
line and stretching it across the page, but without success. This was
originally written in Access 2003, but Access 2007 doesn't fix the problem,
either.
Thanks for any help!