Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2016-10-19
10
Medium Priority
?
66 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 52

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 52

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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 40

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 52

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 52

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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

876 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