Vertical Text: MS Access Report

[TomT]

Is there any fix or workaround for the bug in vertical text in Access 2003
(http://support.microsoft.com/?kbid=839779)?

I cannot get text to appear vertically in either a text box or label.

Thanks,

TomT

 

[Peter Yang [MSFT]]

Hello Tom,

I understand that you'd like to know if there is any fix or workaround for
the known issue documented in KB 839779.

Based on my research, this issue has been reported to developer team and
the fix may not be available currently since the issue might be related
some combination of installed fonts or international/regional settings on
the machine.

Developer team may need to evaluate the impact of the issue and complexsity
to provide a reasonable fix/workaround. I do understand your concern in
this scenario, I highly suggest you can submit this feedback to our product
feedback center so that product team can hear from you directly:
http://www.microsoft.com/office/community/en-us/wizard.mspx?type=suggestion&
lang=en&cr=US&cat=en-us-office&pt=3a4e9862-cdce-4bdc-8664-91038e3eb1e9

workarounds I know of are:

1. Use a different font. This issue only occurs for some font, and you may
try to use a different font such as Arial Narrow to see if it helps. Did
you try different fonts on the report? Did you try differnt regional
settings to test.

2. Save the text in an image file and embed it.

3. Search for possible third party control. For example: www.fmsinc.coml.
Please note we cannot make any representations regarding the quality,
safety, or suitability of any software or information found there.

I'm sorry for any inconvenience this may have brought. If you have any
further comments or feedback on this, please feel free to let's know. Thank
you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Chuck]

Is there any fix or workaround for the bug in vertical text in Access 2003
(http://support.microsoft.com/?kbid=839779)?

I cannot get text to appear vertically in either a text box or label.

Thanks,

TomT

If the vertical text is a constant in a report header, one solution is to make
an Excel worksheet with the headers layed out exactly as you want them. Then
copy and paste into the report header.

Chuck
--

 

[TomT]

I suspect the problem I'm having has to do with IE 7. I recently installed
this on my system, and noticed the problem after that. A client of mine also
installed IE 7 and the vertical text stopped working after that. The client
then un-installed IE 7, and the vertical text worked properly.

I have not un-installed IE 7 myself, but this does seem to point towards a
relationship between IE 7 and the vertical text problem.

 

[TomT]

Thanks Chuck, unfortunately it's not a constant....

 

[Peter Yang [MSFT]]

Hello Tom,

I tried to install IE7 on my test machine and I did not see any
differences. However, I did see some reports on this kind of issue in our
database. I think this might be machine specific related to regional
settings and fonts you use.

You may want to temporarily uninstall IE 7 on the machine to see if it
resolves the problem. Also, did you try different fonts and regional
settings (my setting is US English)?

Please rest assured that this issue is reported to the proper channel and I
also suspect it might be related to the original issue mentioned in KB
839779.

To get more information on this issue, will you please collect the msinfo
of your machine so that I may compare with that on my test machine? You
could send it to me at (e-mail address removed)

http://support.microsoft.com/kb/184075
Description of Microsoft System Information (Msinfo32.exe) Tool

Also, I have found another third party site that might be work around this
issue.

http://www.lebans.com/rotatetext.htm

I look forward to your reply. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

 

[Peter Yang [MSFT]]

Hello Tom,

I'm still interested in this issue. Did you try to uninstall IE to test?
Will you collect the information of the system as I suggested? If you have
any comments or questions, please feel free to let's know. We look forward
to hearing from you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

 

[John Regan]

Hi Peter

I had the same problem since installing IE7. Other PCs in our organisation
that had IE6 didn't have the problem but they all developed the problem once
IE7 was gradually rolled out.

Below is a thread I posted a couple of weeks ago but unfortunately never had
a reponse to which also tells you how to reproduce the problem.

---------------
I've found a problem in Access (I'm using Office XP) that appeared after
installing IE7.

If you have a vertical control (label or text) on a report with Arial font
it will print in what appears to be Times New Roman.


To reproduce:
Create a new report
On it place a label control and set its Caption property to "anything you
like"
Make sure the Font is set to Arial
Set Font Size to 20 to view easier
Now copy & paste the control
Set the copied control's Vertical property to Yes
Resize as necessary


Now Print


This is weird, the horizontal label prints as Arial but the vertical one
prints Times New Roman
I've just noticed that it doesn't have to be arial font, most other fonts
still print out as T N R
On machines that still have IE6 this behaviour doesn't occur.


This is scary
Any one any ideas on how to correct this problem or is it a bug?

 

[KLP]

I uninstalled IE 7 and it works like it should.

No IE 7 for me!

Kelvin

 

[Ahenri]

Hello Peter,

I can confirm the problem in Access 2003 on WinXP SP2 - Nowegian version.
Vertical text appears with IE6, but not with IE7 (it seems that a few pixels
of the first letter is visible, but that's all)

The problem appears / disappears when installing / uninstalling IE7.

I have dumped SystemInfo, but it is all in Norwegian...

Very annoying this "little" problem - and since it dates back to 2004, it
would be great if someone can come up with a solution...

Best regards
Axel

 

[Memo Rivera]

I can confirm that by uninstalling IE7 you solve the problem.
And until the bug is fixed ¡Goodbye IE7!

 

[PCEDV]

I also was in deep trouble (one of my access applications prints out machine
readable payment forms with vertical text fields holding codes in
OCR-B-font!).
The problem also disappeared after deinstalling IE7!
Regards, peter