Rotate Text Box 180 degress (upside down)

[razorking]

I have a question that I don't think can be solved - practically speaking - in access. But let's try:

I have a report that has a text box bound to a field on a query. I want that text box to be rotated upside down on the report. Any way to do this?

 

[wiklendt]

i've done a quick google search and seems there is no 'real' way. one work-around which may suit you is perhaps to add this upside-down text as an image... which will obviously only be useful if it is not bound to varying data in a table...

 

[wiklendt]

then again, this might give you some ideas:

http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/36c36e4fb6227a79

 

[razorking]

We have considered an image to represent the text and I may have to resort to that. The data is "non variable" so it could be an option.

The need is legitimate, we are using data in a table to create a label (report) in Access. What we are doing is we have a sample tile, the sample is approx 3/4" thick. We want to print labels that cover the back of the sample, and the top of the label will fold over the top edge - covering the 3/4". Ideally that top portion of the label will face the person who is looking at the front of the sample.

 

[ChrisO]

Just a bit of fun; see attached.

 

[Zaeed]

I can't test this on my work machine, but I would try installing an upside down font, and then formatting the text field to that font type..

Google upside down fonts

 

[Galaxiom]

Remember with upside down fonts you will have to reverse the direction of the text too.
Don't have to use code for this as there is a property: ReadingOrder.
The value for reverse order is 2.

 

[DCrake]

If your labels are non variable as you put it why not create the labels as images and link them to the tiles then use the picture in your report.

David

 

[razorking]

I think I will give the upside down font a go and see how that works. What I don't like about it is I can't use the same field - ideally I would use the item name field twice, once right side up and at the top of the label upside down. The upside down font means I have to key data twice, and probably will mean keying not importing from another source, and probably keying it in backwards. But - hey, it's an imperfect world.

I did not understand the database ChrisO attached - don't see anything upside down on the report - was I supposed to?

And have tried the image approach, so far not liking it too well. This is 4x4 label and the text as an image looks kind of funky - it does not look clean and I think I will have issues getting it sized correctly and so forth.

Interesting in that when I first undertook this task I assumed an upside down text box would be a piece of cake. I wonder about the possibility of using another program for the label - am sure Bartender or something could do it. But the label is fairly basic and I would like to use the database as the source of the data. Can Publisher or Word link to a database? And can I rotate text 180 in those programs -sorry....thinking/typing outloud.

 

[razorking]

Remember with upside down fonts you will have to reverse the direction of the text too.
Don't have to use code for this as there is a property: ReadingOrder.
The value for reverse order is 2.

The upside down font is a viable option. But I do have to type the text in backwards - unless I can find a way to automate that.

I don't understand the reading order property - I can change it to right to left - but it does seem to actually change anything regardless of how I change it.

 

[razorking]

I did find several reverse text generators online - http://textop.us/Text-tools/Reverse-Text

Would there be a way to reverse the text within access?

 

[Galaxiom]

Would there be a way to reverse the text within access?

Remember with upside down fonts you will have to reverse the direction of the text too.
Don't have to use code for this as there is a property: ReadingOrder.
The value for reverse order is 2.

It is available through the property sheet or using VBA.

 

[razorking]

I found it on the property sheet for the text box. But what I am saying is that nothing changes when I change the setting. The setting is Reading Order. The options are:
Context
Left-to-Right
Right-to-Left

But when I change these the text as displayed on the report does not change. And it does not matter if it is the newly acquired upside down font or one of the regular fonts.

 

[boblarson]

I did find several reverse text generators online - http://textop.us/Text-tools/Reverse-Text

Would there be a way to reverse the text within access?

Check out the strReverse function.