Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Modules: Rotate Label ActiveX Control

Author(s)
Stephen Lebans

INFORMATION PROVIDED IN THIS DOCUMENT AND THE ROTATELABEL ACTIVEX CONTROL ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED. THE USER ASSUMES THE ENTIRE RISK OF RUNNING THIS SOFTWARE.

1999-2002, Stephen Lebans (http://www.lebans.com).

Download Rotate.zip (Version 2.0)
  See Screenshot

The purpose of the Rotate Label ActiveX control is to produce Rotated Text in Microsoft Access. This control mimics a normal Access TextBox control. It has a RecordSource property so that it can be bound to a field or contain an Expression.

When you have installed the Runtime Files, you need to register RotateLabelVer2.ocx and Msstkprp.dll

To use the control in Access, simply goto the Insert menu and select ActiveX controls. The ListBox that pops up should contain a listing "Access RotateText control 2.0".  

Once the control is inserted on your Form or Report you  can double click or right click and select Properties to get at the control's properties.There is an online Help File, though it is slightly dated! :-) 

A large percentage of ActiveX controls do not function properly within the VBA Access environment. A lot of it has to do with differences in the Extender and Ambient control properties. It took a lot of trial and error to get this control to work in both Form and Report views. 

Include with the Source files are the compiled ActiveX control and the required Property Page DLL file. 

  • RotateLabelVer2.ocx ActiveX control
  • Msstkprp.dll Property Page DLL 

Enjoy 
Stephen Lebans

You must have the VB6 Runtime Files to use this control. The runtime files can be downloaded here. Or you can get RotateLabel.zip from my Web Page. If you are not comfortable manually registering Ocx and DLL files, I would suggest you download one of the SelfInstall RotateLabel packages from my Web Page.

 

1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer