Text rotation

Topic

New Reply

Is there any way to print control text vertically in Access 97 reports.

Reply | Quote

Replies

Not with native Access 97 controls. There are, I believe, third party controls that will allow you to do that.

Reply | Quote

Thanks. Do you know where I might get them.

Reply | Quote

I can’t endorse any of the vendors because I haven’t tried any. However, I know that Stephen Lebans has something on his excellent site at http://www.lebans.com/rotatetext.htm.

Reply | Quote

Hi Tom

Print Vertical Text (Bottom to Top)?
A2k (9.0.3821) SR-1

After much research to print vertical bound control text on my cleint

Reply | Quote

Just a warning.

After finding this thread while searching the forum for a solution to a similar problem — we downloaded and used the Tilt 1.2 program John mentions in his post.

Seemed to work like a charm.

Except that this was a report on an shared Access database out on a group company drive. So whenever anyone else tried to open the report, they would get an error message that it was looking for the Tilt 1.2 function. (we are using Access 2003)

so, in other words, we would have had to put Tilt on the machines of everyone wanting to view or work on the report from the database. So this obviously was not the best solution.

We removed Tilt and dropped back to using the cut/paste from Excel method to rotate the text the direction we needed.

pribb

Reply | Quote

pribb

That is corect

Tilt12.exe installs to C:Program FilesTilt12Tilt12.dll on each client’s computer

I only needed it for one report.

Not familiar with Excel, what would the cut and paste code you suggested look like?

Thanks, John

Reply | Quote

Can you do this in a2k

Reply | Quote

Yes. Set the vertical property of the text box to Yes.

Reply | Quote

Hi Steve

My text control prints (top to bottom) vertically OK in a2k, however I

Reply | Quote

John,

You might try setting up your rotated text in Excel. Then, you can copy it to the clipboard, edit as needed and pop it into an image control in Access. Or, you could tell your label to look for the image file you just edited.

Of course, this idea won’t be very efficient if you have to do this more than once. Then, as mentioned above, third-party controls are a much better alternative.

HTH,

Tom

Reply | Quote