Solved

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

Posted on 2016-10-19
10
32 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 36

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server views 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 Access…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

830 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