Help!

Text Direction In Access

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Reports RSS
Next:  Total sales by day of week  
Author Message
Jonathan Hope
External


Since: Sep 21, 2004
Posts: 1



PostPosted: Tue Sep 21, 2004 9:04 am    Post subject: Text Direction In Access
Archived from groups: microsoft>public>access>reports (more info?)

Does Anybody know how to change the text direction on a
report so it reads sideways, i need this to fit all my
fields on a cross tab report onto one page. Im running MS
Access 97

Any assistance iin this matter would be greatly
appreciated.

Jonathan
Back to top
Jeff Boyce
External


Since: Oct 17, 2003
Posts: 2640



PostPosted: Tue Sep 21, 2004 10:16 am    Post subject: Re: Text Direction In Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Jonathan

I believe you can use File | Page Setup to change the orientation of the
paper to Landscape when you are in design mode for the report.

--
Good luck

Jeff Boyce
<Access MVP>
Back to top
Jonathan Hope
External


Since: Sep 21, 2004
Posts: 1



PostPosted: Tue Sep 21, 2004 10:54 am    Post subject: Text Direction In Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

 >-----Original Message-----
 >Does Anybody know how to change the text direction on a
 >report so it reads sideways, i need this to fit all my
 >fields on a cross tab report onto one page. Im running MS
 >Access 97
 >
 >Any assistance iin this matter would be greatly
 >appreciated.
 >
 >Jonathan
 >.
 >

Further to this i did find a way but its far from ideal, i
copied the fields to excel and then edited them to show
the correct text direction, then imported back into access
as an image, this is a horid way of doing things becouse
it is so inflexible.

but hey sometimes you have to work with whats given to you
with access.
Back to top
anonymous
External


Since: Oct 15, 2003
Posts: 3520



PostPosted: Tue Sep 21, 2004 10:58 am    Post subject: Re: Text Direction In Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks Jeff but unfortunately this would change direction
of all text, i need to change the fields going
horizontally to read downwards leaving the vertical fields
to read across.

Jonathan
 >-----Original Message-----
 >Jonathan
 >
 >I believe you can use File | Page Setup to change the
orientation of the
 >paper to Landscape when you are in design mode for the
report.
 >
 >--
 >Good luck
 >
 >Jeff Boyce
 ><Access MVP>
 >
 >.
 >
Back to top
Little pete
External


Since: Oct 11, 2004
Posts: 29



PostPosted: Tue Sep 21, 2004 11:35 am    Post subject: RE: Text Direction In Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

dude
go into the properties of the field/s, Other tab, change vertical to YES
Then play around with the field shape/size

sweet

"Jonathan Hope" wrote:

 >
  > >-----Original Message-----
  > >Does Anybody know how to change the text direction on a
  > >report so it reads sideways, i need this to fit all my
  > >fields on a cross tab report onto one page. Im running MS
  > >Access 97
  > >
  > >Any assistance iin this matter would be greatly
  > >appreciated.
  > >
  > >Jonathan
  > >.
  > >
 >
 > Further to this i did find a way but its far from ideal, i
 > copied the fields to excel and then edited them to show
 > the correct text direction, then imported back into access
 > as an image, this is a horid way of doing things becouse
 > it is so inflexible.
 >
 > but hey sometimes you have to work with whats given to you
 > with access.
 >
Back to top
Jonathan
External


Since: Nov 06, 2003
Posts: 10



PostPosted: Tue Sep 21, 2004 12:02 pm    Post subject: RE: Text Direction In Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

don't seem to work pete i cant find vertical anywhere?
are you using 97 or a later version?
 >-----Original Message-----
 >dude
 >go into the properties of the field/s, Other tab, change
vertical to YES
 >Then play around with the field shape/size
 >
 >sweet
 >
 >"Jonathan Hope" wrote:
 >
  >>
   >> >-----Original Message-----
   >> >Does Anybody know how to change the text direction on
a
   >> >report so it reads sideways, i need this to fit all my
   >> >fields on a cross tab report onto one page. Im running
MS
   >> >Access 97
   >> >
   >> >Any assistance iin this matter would be greatly
   >> >appreciated.
   >> >
   >> >Jonathan
   >> >.
   >> >
  >>
  >> Further to this i did find a way but its far from
ideal, i
  >> copied the fields to excel and then edited them to show
  >> the correct text direction, then imported back into
access
  >> as an image, this is a horid way of doing things
becouse
  >> it is so inflexible.
  >>
  >> but hey sometimes you have to work with whats given to
you
  >> with access.
  >>
 >.
 >
Back to top
es
External


Since: Mar 23, 2004
Posts: 10



PostPosted: Tue Sep 21, 2004 1:48 pm    Post subject: Text Direction In Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Have you tried the Vertical property for the field in
design mode?

 >-----Original Message-----
 >Does Anybody know how to change the text direction on a
 >report so it reads sideways, i need this to fit all my
 >fields on a cross tab report onto one page. Im running MS
 >Access 97
 >
 >Any assistance iin this matter would be greatly
 >appreciated.
 >
 >Jonathan
 >.
 >
Back to top
&quot;John Spencer
External


Since: Dec 29, 2003
Posts: 295



PostPosted: Wed Sep 22, 2004 12:55 am    Post subject: Re: Text Direction In Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Try the rotateText at

http://www.lebans.com/rotatetext.htm

http://www.lebans.com/DownloadFiles/AccRotextWMF.zip


Jonathan Hope wrote:
 >
 > Does Anybody know how to change the text direction on a
 > report so it reads sideways, i need this to fit all my
 > fields on a cross tab report onto one page. Im running MS
 > Access 97
 >
 > Any assistance iin this matter would be greatly
 > appreciated.
 >
 > Jonathan
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Reports All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum