Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2016-10-19
10
Medium Priority
?
54 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 51

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 51

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 39

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 51

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 51

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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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