Solved

MS Access Report. Label Text Wrapping when it should not be.

Posted on 2016-10-19
10
28 Views
Last Modified: 2016-10-29
Hi Experts,

I'm suddenly having an issue where the headers of some of my reports are wrapping, even though their is more than enough room in the text box when I see it in design mode. Anyone else having this issue? Anyone know why or the solution. I windows 10 was updated today. The other thing that I noticed was that the first time I tried to open my VB editor, it started doing a re-install. Strange.

Take a look at these pictures:

This is in Design View.
This is in print preview.
And unfortunately it's happening with other reports.

Any help would be greatly appreciated.
0
Comment
Question by:eantar
  • 5
  • 4
10 Comments
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 41851062
even though their is more than enough room in the text box

That's what you think.
See again. There isn't, as the printed text is spaced more widely.

So just widen your label.

/gustav
0
 
LVL 5

Author Comment

by:eantar
ID: 41851087
Hi Gustav,

I get it. But here's the thing, this report has been out there WITHOUT this issue for a long time. This just showed up today. And like I said, it's happening with many other reports. Suddenly.

Any thoughts?

-e
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 41851102
That's harder.
You could try a system restore - if success, it has to do with the update.

/gustav
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 35

Expert Comment

by:PatHartman
ID: 41851183
I got some Windows updates pushed at me a couple of days ago and now the computer freezes after about 5 minutes and requires a reboot.  I'm considering switching to UNIX or a MAC.  MS has gotten on my last nerve with this business of sending out untested updates.

Anyway, chances are the update messed this up.  If the app still works on other computers that haven't been updated, you'll know for sure.

When things like this happen, MS may or may not issue a hotfix.  It depends on how many people complain and how destructive the bug is.  MS will most likely categorize this as an annoyance and not rush to resolve it so you're going to end up having to adjust the headers.  I feel your pain - Just waiting for it to happen to me.

WYSIWYG in Access has never been good anyway.  Now it seems to be worse.
0
 
LVL 5

Author Comment

by:eantar
ID: 41851269
I'm thinking about reinstalling my original version of Office 2010.

thoughts?

-E
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 41851571
That won't hurt, but try a repair of the installation first.
Or move to Office 2016 which works very well.

/gustav
0
 
LVL 5

Author Comment

by:eantar
ID: 41852255
Does it? I was curious about 2016. Any glitches? Things to look out for? Benefits?

Thanks.
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 41852294
Well, 2010 is two versions back now, and have used 2016 (32-bit only) from the very first release with zero issues on Windows 8.1/10 (64-bit).
But, as always, your mileage may vary.

/gustav
0
 
LVL 5

Accepted Solution

by:
eantar earned 0 total points
ID: 41857588
Hi all who have been following. I figured it out. It seems that after the last Windows 10 update, my Brother Printer Device Driver was missing. So my system defaulted to something else, something strange. Anyway, once I opened my printer up, the Device Driver re-enstalled and all the reports showed up normal.

Still, I wish updates wouldn't do that.

Best,
EAntar
0
 
LVL 5

Author Closing Comment

by:eantar
ID: 41865074
I found the issue through trail and error.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question