Access Report Text is cut off

I have a report with a comments (memo) field.  The field is set to can grow/can shrink on the report.  Normally, all is OK but sometimes, the last line or two get cut off.

Ideas?
LVL 14
Bill RossProgrammerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
Is the detail section also set to can grow/can shrink?
0
Bill RossProgrammerAuthor Commented:
Yes, the control is in the detail and both the control and the section are set to CanGrow/CanShrink=yes.  Also, as an aside, the behavior only seems to happen for users with Office/Access 2016.  No issues have been reported with Access 2007/2010 users although they may have the issue and just not reported it.  I cannot duplicate the issue.  It is random...
0
PatHartmanCommented:
Is everyone using the same printer?
Does everyone have the correct printer driver installed?
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

Bill RossProgrammerAuthor Commented:
Good point.  I will check.  Probably cannot find out until Wed.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Ideas?>>

 Your first check should be if the entire notes field is returned by the query the report is based on.   Some query operations will cause a memo field to truncate to 255 characters (i.e. a SELECT DISTINCT).  There are ways around that.

 Open the query on it's own and see if the data is there.   If the report is based directly on a table, this does not apply.

Jim.
0
Bill RossProgrammerAuthor Commented:
Hi Jim,

Query returns correct data and it does not seem to be related to the data length.  According to the users, the report in question is missing one line of info.  I tested the query and the field data length is 975 characters.  I'm thinking it might be a font issue.  The report uses Arial font.  I'm having the user test to see if Arial is installed as well as the printer set up as suggested by Pat.

Other ideas?

Thanks,

Bill
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<  I cannot duplicate the issue.  It is random...>>

 Will be a tough one to nail down then.    

 Only other thing that comes to mind is that in the past, specifying a line spacing other than zero would sometimes mess it up.

 I think the key here though is to get a reproducible sample as it sounds like an A2016 bug.    The can grow/shrink has always been a bit of a pain.   Often it's not obvious what the cause is because there are so many factors involved.

 When I have a problem like this with a report, I usually strip every special feature out (keep together, forcing page breaks, etc) except for the one feature that is not working.   I get it working (or realize it doesn't work at all), then add in each feature until I find the problem.

Jim.
0
Bill RossProgrammerAuthor Commented:
OK.  Thx.
0
Bill RossProgrammerAuthor Commented:
No help.  Various printers and Arial font installed.  Only last line is cut off and it is seemingly random.  Only Access 2016/Win7 but I cannot duplicate on my test machine.

Any other ideas?

Thanks,  Bill
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Is this at the bottom of the section and when does it truncate?   Bottom of page or no?

Not sure what the layout of the controls is, but only thought at the moment is to make it really big and let it shrink.

I might also play with the width and along the lines of Pat's suggestion, try a mono-spaced font (Courier New or Lucida Sans Typewriter).  There are some others floating around as well.

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bill RossProgrammerAuthor Commented:
Big is not an option as some comments are only one or 2 lines and that would be problematic leaving half the page blank.  I will try the different font idea.  Thanks,  Bill
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Big is not an option as some comments are only one or 2 lines and that would be problematic leaving half the page blank.  >>

 It shouldn't leave any blank space.....make the control big and set it to can shrink.

Jim.
0
Bill RossProgrammerAuthor Commented:
Hi Experts,

Well I finally went to the client and saw the issue.  Could not duplicate it on my set up.  Turns out the user copied text from MS Word into the comments field.  There were hidden characters causing the issue.  I copied to notepad and pasted back into the memo field and report worked fine.

Does anyone know how to prevent this?  Strip out the non-text characters?  It's a simple text box with maybe 2000 text characters.

Thanks,

Bill
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
You'd have to loop through the text looking for characters outside of the normal ASCII range.

There's nothing built in that would do it for you.  Plenty of code examples floating around.

Using Like:

https://www.experts-exchange.com/questions/24454280/Best-way-to-remove-non-ascii-characters.html#a24520543

Using InStr (my choice):

https://www.experts-exchange.com/questions/24454280/Best-way-to-remove-non-ascii-characters.html#a24529399

Jim.
0
Bill RossProgrammerAuthor Commented:
Hi Jim,

Thanks and thanks to you all.  Problem solved.

Bill
0
Bill RossProgrammerAuthor Commented:
The font suggestion was the key.  I really appreciate the help!  Thanks, Bill
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.