[AccessD] Vertical Text

Mark A Matte markamatte at hotmail.com
Mon Jan 5 09:41:18 CST 2009


Ok....WAYYYYYY outside the box...
 
In reading this thread I thought..."I know I have done this in Access before"...but could not remember where or how...
 
Well, not exactly...turns out I was remembering doing this with a Chart Title.  Chart Titles can be controlled and oriented just as you have described.
 
Not saying its a pretty solution...but in a pinch...you can create a chart...orient your title...delete all other objects...then delete the data from the datasheet...on the form change the chart object's size mode to clip...and voila...you have a vertical text box from bottom to top.  You may have to play with the Chart Title Font...and the Chart Font...also turn off "Auto Scale" in both chart font...and chart title font.
 
As I said...not pretty...but printed and on-screen...can't tell the difference.
 
Now...if someone can tell me how to get the Chart title off the chart...and on the report...that would be cool.
 
Hope it helps...
 
Mark A. Matte
 


----------------------------------------
> From: rockysmolin at bchacc.com
> To: accessd at databaseadvisors.com
> Date: Mon, 5 Jan 2009 05:43:28 -0800
> Subject: Re: [AccessD] Vertical Text
>
> For a minute there I thought we had it - the too simple solution. But I
> tried it and the text box reads tneilC.
>
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
> www.bchacc.com
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
> Sent: Sunday, January 04, 2009 11:35 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Vertical Text
>
> Why not just spell Client backwards? Or am I missing something?
>
> On Sun, Jan 4, 2009 at 11:27 PM, Rocky Smolin at Beach Access Software <
> rockysmolin at bchacc.com> wrote:
>
>> Dear List:
>>
>> I need to put a label on a report and have it print vertically. The
>> Vertical property does this but I need it reversed - that is, the
>> label says 'Client'. With Vertical the C is at the top and the t is
>> at the bottom.
>> What the client wants is the C at the bottom and the t at the top.
>>
>> Any way to do this short of an ActiveX? (Lebans has one but maybe
>> there's a more simpler approach.)
>>
>> MTIA
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
_________________________________________________________________
It’s the same Hotmail®. If by “same” you mean up to 70% faster.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad1_122008



More information about the AccessD mailing list