Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Isolated Can Grow Not Working

Status
Not open for further replies.

riles01

MIS
Mar 4, 2003
8
US
I have a report that I recently updated by adding a few additional fields, one of which needs more than 255 characters to display. I have checked my queries, and they are working fine. The other memo fields grow just fine. This new one, however, grows an additional row and stops at 255 characters. I've recreated the text field several times and checked that no borders are overlapping. Any ideas? Is there a limit to the number of fields that can grow at one time?

Regards,
Ryan
 
If more than 255 characters display in the report's record source datasheet view, then make sure the text box doesn't have a value in the format property.

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]
[blue]Ask me about my grandson, get a grand answer.[/blue]
 
Thanks, Duane. I actually ended up using a DLookup instead as I needed the report yesterday. It's slower, but it is working. It was showing up as more than 255 characters in the datasheet view, and there wasn't anything in the Format property.

Thanks for your help,
Ryan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top