Solved

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

Posted on 2016-10-19
10
22 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
 
LVL 34

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Backup Your Microsoft Windows Server®

Backup 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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

920 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now