I am using an Access Database to produce a report for a catalog of stage plays. One of the fields is a memo field which holds the synopsis of the play. Seemingly at random, the query (and hence the report) misses off part of the end of this field. There is no common feature about the records it misses characters on. It's not a character count or anything like that, and I've deliberately set the field to maximum width in the query and the report so there should be no danger of right hand side cutoff.
I've even changed the font size to 8pt to fit the maximum number of characters in, but all to no avail. I can't predict which records it will trncate, only that, in a catalog of maybe 330 plays, six or seven will have this problem, meaning I have to maunually check the output and alter it where necessary.
Any ideas?
I've even changed the font size to 8pt to fit the maximum number of characters in, but all to no avail. I can't predict which records it will trncate, only that, in a catalog of maybe 330 plays, six or seven will have this problem, meaning I have to maunually check the output and alter it where necessary.
Any ideas?
