Rotating Text

[Guest]

I need to rotate text on my report to read sideways, bottom-to-top. I'm
having trouble with the Stephen Lebans approach which I will describe below
but first I'd like to ask the Microsoft reps out there if Microsoft is going
to build something into MS Access to solve this problem or if they are going
to continue to just ignore it?

Many thanks to Stephen for developing a workaround solution. Hopefully I can
get it to work.

I am using Access 2003 on WinXP Pro. I've placed a label on my report with
the Tahoma true-type font, Label104, with 90 in the Tag. I've also placed an
Image control, Image106. In the Detail-Print code I put:
Dim varx As Variant
varx = fRotateRunTime(Label104, Image106)
I copied the code for fRotateRunTime into a module and compiled the project,
no errors at compile time. When I try to open the report I get "Error: cannot
create metafile".

Any help woud be greatly appreciated.

Thanks, Herb

 

[Peter Yang [MSFT]]

Hello Herb,

As I know, there is no built in feature to do this in Access currently.
Please rest assured your feedback on this is routed to the product team
again.

As for the error you encounter, "Error: cannot create metafile", it seems
to be caused by that there is existing RotateTemp.EMF in the following
folder.

C:\Documents and Settings\<user name>\Local Settings\Temp\RotateTemp.EMF

You may want to close Access, and remove above file, and test the report
again. It seems the file is not removed properly due to some issues or you
call the function several times concurrently.

If you have any further feedback or comments, 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.

 

[Stephen Lebans]

Ouch...Peter this was the first thing I ever wrote in Access many years ago.
I obviously did not know about temp files way back when.

The only time the file is left behind is if the user is in Debug mode and
stops the execution of the code before cleanup. In that case your
instructions to the OP are correct. I need to update this solution to use
temp files as all of my other later solutions do.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Peter Yang [MSFT]]

Hello Stephen,

Thank you for your clarification! Your solution apparently benefit the
community!

Best Regards,

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

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

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


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