Can Grow in Report Still Not Showing All Data

[Valeriya]

Hello,
I have Access 2000, and I have a report with a text box which has the "Can Grow" & "can Shrink" set to yes. Regardless, it still doesn't show all the data of the text box.

Tips?

Thanks,

Valeria

 

[PHV]

Tips?
Yes, a more suited place to ask:
forum703

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lameid]

Also, you may need to set the can grow of the section to yest in addition to the textbox.

 

[maxhugen]

Also check that any other fields at left, right, top, bottom are absolutely not overlapping, even by a pixel, or it probably won't work.

Max Hugen
Australia

 

[Valeriya]

Thank you Guys for your responses! But unfortunately,tried all of your fixes,none of them worked. I've also tried to adapt VBA "TextHeightWidth" solution, offered by Stephen Lebans and it hasn't worked either. Please advise, what else could possibly cause that kind of problem?

Thank you in advance!

Valeriya

 

[lameid]

Is it not scrolling across pages or just truncating it on the same page?

What happens if you make a report that displays only the textbox with the can grows set and only the one record? Does it work then?

If so you could try making a copy of your report and delete things until it works narrowing down what causes it to fail.
By things I mean conrols, sections, sorting (would not expect sorting).

Also Making a blank report and copying things to it until it doesn't work may prove fruitful or end up in a report that works.

 

[Valeriya]

Hello,

Thanks lameid for you advise, but unfortunately that hasn't work either. I created blank report that displays only the textbox with the can grows set for only that problem record.
And it's still showing truncated on the same page.

Please advise,

Thanks in advance!

Valeria

 

[lameid]

It sounds like there is so much text in the text box that it can't fit on a page no matter what.

I'm a little surprised that it won't span pages. If it was too wide it would roll on to the next page. You might try tinkering with columns and pages in an attempt to achieve this effect intentionally but I doubt it would work... It probably forces all columns to fit in the printable space.

The easiest solution may be to break the text up into multiple records. You might also try searching the report forum and it's faq for a solution.

 

[lameid]

I ran accross a report of mine that has no problem spanning a page.

As long as the Can Grow property is set for both the control and the section, you should not have a problem.

 

[dhookom]

I expect the query might be the problem. Check the datasheet view of the report's record source to see if the data is being truncated in the query. If the query/datasheet is ok, make sure the Format property is empty.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Valeriya]

THANKS a LOT for all of your advises!
But it seems like dhookom was right, the problem with that memo field is that the data is being truncated in the query that report is based on.


Now I'm stuck again and hoping for some help.
The Report that currently has this problem is based on the query.
Query in sequence is based on the table that gets populated from the user input form.
I've checked this Filed in the source Table, the data is fully displayed and nothing is truncated there.

Though can't find the place where I can change the setting or adjust the format in the Query for that field?

Thank you in advance!

Valeriya

 

[Valeriya]

Hey Guys,
Just figured out that I was wrong in my previous post, saying that data are not truncated in the table.

It is truncated in the Table, but all data fully displayed on the Form. (???)

The following is the "problem" Text Box Properties:

Text Box Scope:

FORMAT EMTRY
DECIMAL PLACES: AUTO
CAN GROW: YES
CAN SHRINK: YES
LEFT: 1"
TOP: 2.2083"
WIDTH: 6.8333"
HEIGHT: 1.1979"
VISIBLE YES
DISPLAY WHEN ALWAYS
SCROLL BARS: VERTICAL
ENETR KEY BEHAVIOUR NEW LINE IN FIELD
ALLOW AUTO CORRECT: YES
VERTICAL NO
AUTOTAB NO
TAB STOP YES

Thanks a lot!

Valeria

 

[dhookom]

I'm confused. If the data is being truncated in the query then why tell us about the text box properties?

What is the SQL view of your report's record source?
Is the text box located in a group or report header or footer?
Do you have any format property settings for this field in the table design or anywhere?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lameid]

It is truncated in the Table, but all data fully displayed on the Form. (???)

So you enter data in the form and never close it so you are not seeing what is saved?

Otherwise it has to be in the table, in which case check any display properties on it.

 

[Valeriya]

Hello,

Sorry for the confusion Guys.
Let me clarify the problem again:
1.The Report with truncated data in the Text Box is based on the Query.
2. That Query is based on the Table
3. Table in sequence gets populated from the Form.

Everything is looks good until it gets to the Query.
What I mean by that is that data in the Scope field in the table is fully displayed.I've checked the properties as well, the Data Type is Memo and it doesn't have any formating in place.

However when it comes to a Query or Report, that Memo field Data is truncated.
Hope this time I explained more clear.
The whole point for that "form-table -query " is to be able to generate the report which I can't figure out...

Thank you in advance,

Valeriya

 

[dhookom]

Can you answer the three questions that I asked?
[blue][tt]
What is the SQL view of your report's record source?
Is the text box located in a group or report header or footer?
Do you have any format property settings for this field in the table design or anywhere? [/tt][/blue]

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]