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.
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?
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.
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.
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.
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]
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?
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
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]
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...
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]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.