Upside Down Text Box in Reports

[KLK000]

Is there a way to turn a bound text box upside down in an Access Report? We want to print "Tent" cards for Students in a class (You know, those silly Name cards that sit in front of each Student) and we want the name to appear on both sides of a folded 8.5x11 card.

 

[SgtJarrow]

What version of Access??? I beleive 2000 has a text rotation field and you could set it to 180 degrees....never done it myself and I don't have 2000 here at the office.... Programming isn't a profession of choice.
It's a profession of calling...
"Hey Programmer, your application broke again!"

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer

 

[KLK000]

I'm using Access XP. I've checked and can't find any field/property that will allow me to set the rotation to 180. Maybe I just don't know where to look.

 

[GoDawgs]

I don't see a way to do this...I thought for sure there'd be an option like in Word, but I haven't found it...sorry.

Kevin

 

[jebry]

Hi!

Check the following site:

http://www.lebans.com

There is code there to turn a button's text upside down, I'm not sure there is any for a text box.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[KLK000]

I tried out the code at this site and it runs great on a command button control rotating the text 180 degrees just like I want. However, when I try running the code on a text box I receive an error message saying you must select a command button control. I reviewed the code to see if it can be easily modified but it's a lot more than I'm willing to tackle. I just can't believe that MS Access has no easy way to rotate text on a report... or maybe I shouldn't be surprised.

 

[LarryDeLaruelle]

The nearest thing in Access (2000)is the Vertical property (Other tab). Seem to be available for labels and controls.

However, it only turns 90 degrees right. Probably won't solve the tent card problem. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[KLK000]

No, unfortunately the Vertical property doesn't solve the tent card problem. In lieu of a simple way of doing this with an Access Report, I'm somewhat considering somehow interfacing the Report (or maybe a Form or just through code) with MS PowerPoint which allows you to rotate labels. Now to figure out if/how this can be done. Maybe I'll start another thread. In the mean time, I'll keep checking this thread just in case someone finds an easy way to rotate a text box. Thanks for all the responses. It's nice to know people are willing to help out.

 

[jebry]

Hi!

Another thought has occurred to me. You should be able to open a Word doc(or template) and insert Word Art with the names you need. Word Art can be rotated 180 degrees. I don't know that you can automate this from Access but I recorded a macro in Word doing this and got this code:

ActiveDocument.Shapes.AddTextEffect(msoTextEffect14, "Jeff Bridgham", _
"Impact", 36#, msoFalse, msoFalse, 204.75, 108.8).Select
Selection.ShapeRange.IncrementRotation -172.05

I don't know if you can run this from a Word object in Access.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[MichaelRed]

Just "construct" the word doc with the rotated text, then set it up as a mail merge from the db.

You might also check if the RTF textbox permits the necessary degree of rotation.

Third option - just make the comand button (which you know works) "big enough" and set the backcolor property to white. Check into other properties (SpecialEffect?) Should be able to get this to have an "attractive" look.


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[scriverb]

In Word construct a new document setting it up as a Landscape format. Return down from the top to the halfway point and put in a dotted line of hyphens for the foldmark. Now Return down farther and Select 72 pt font. Just experiement. Select Center Alignment and insert a character temporarily. Save the document.

Now go to Access design and select the table with the names. Click the Merge It with Microsoft Word option. Click OK to the Link to existing document. Word will open with your Landscaped document. Highlight the character created earlier and delete. Select from the Insert Merge field dropdown the field from the table with your names. If the field names appears rather than the names click the ABC button above on the Merge toolbar to have the names appear. Now Click the Merge to new document button from the Merge toolbar. This will create a large document ready for printing of your Tent Name stands.

Hope this helps.

Bob Scriver