473,322 Members | 1,259 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

text direction in report

I am working with MS access database for account purpose. I want to generate a report in which the text direction is reuired from Bottom to Top. When I am setting the property for that particular field as vertical it shows the direction from Top to bottom only.
Kindly try to help me.
Jul 13 '08 #1
8 6729
ADezii
8,834 Expert 8TB
This is a rather odd request, but to have the Text Vertically Oriented, properly formatted, starting from the bottom of the Text Box working upwards, you can take the following steps:
  1. Run your values through the following Function, I'll use Last Name as an example, which will be used in the underlying Record Source for the Report as a Calculated Field:
    Expand|Select|Wrap|Line Numbers
    1. Public Function fReverseString(varLastName As Variant) As Variant
    2. Dim intCounter As Integer
    3. Dim strLastNameReversed As String
    4.  
    5. If Not IsNull(varLastName) Then
    6.   For intCounter = Len(varLastName) To 1 Step -1
    7.     strLastNameReversed = strLastNameReversed & _
    8.                           Mid$(varLastName, intCounter, 1) & vbCrLf
    9.   Next
    10.  
    11.   fReverseString = strLastNameReversed
    12. Else
    13.   fReverseString = vbNullString
    14. End If
    15. End Function
  2. Set the following Properties for the Text Box on the Report:
    1. Control Source = Calculated Field
    2. Vertical = No
    3. Can Grow = Yes
    4. Text Align = Center
  3. Any questions, feel free to ask.
Sample Function Call:
Expand|Select|Wrap|Line Numbers
  1. Debug.Print fReverseString("Bytes")
OUTPUT (not centered):
Expand|Select|Wrap|Line Numbers
  1. s
  2. e
  3. t
  4. y
  5. B
Jul 13 '08 #2
missinglinq
3,532 Expert 2GB
This is a very odd request, as ADezii said, but amazingly, one that Access foresaw, with the StrReverse() function.

StrReverse("bytes")
yields " "setyb"

Set the Vertical Property to Yes and size the control so that it's taller than it is wide.

Linq ;0)>
Jul 13 '08 #3
ADezii
8,834 Expert 8TB
This is a very odd request, as ADezii said, but amazingly, one that Access foresaw, with the StrReverse() function.

StrReverse("bytes")
yields " "setyb"

Set the Vertical Property to Yes and size the control so that it's taller than it is wide.

Linq ;0)>
Hello Linq, I don't think that will work since:
  1. The Text Orientation will be 90 degrees off clockwise from true Vertical.
  2. The letters will not be in Reverse ordering, namely, working from the bottom upwards.
Jul 13 '08 #4
NeoPa
32,556 Expert Mod 16PB
I'm confused ADezii :S

Surely StrReverse would produce exactly the same output as your fReverseString?

I can't pretend any experience with vertical printing mind you.
Jul 16 '08 #5
ADezii
8,834 Expert 8TB
I'm confused ADezii :S

Surely StrReverse would produce exactly the same output as your fReverseString?

I can't pretend any experience with vertical printing mind you.
Surely StrReverse would produce exactly the same output as your fReverseString?
Sorry for the confusion, it definately will, but the display will be off true Vertical. Try it and you'll see what I mean.
Jul 16 '08 #6
NeoPa
32,556 Expert Mod 16PB
I'm intrigued. I can't understand (atm) why that might be so.

I will try it but will have to wait for an appropriate moment. I'll post back later with my findings.
Jul 17 '08 #7
NeoPa
32,556 Expert Mod 16PB
Bizarrely, although the TextBox clearly had 5 characters in it, none was visible :S

I tried ADezii's approach, which nearly worked, but I got :
s
et
y
B

The approach can work, I'm sure, but is a little restrictive on control size.

I'm curious to know why a simple vertical display of the text is not visible suddenly :S
Jul 17 '08 #8
ADezii
8,834 Expert 8TB
Bizarrely, although the TextBox clearly had 5 characters in it, none was visible :S

I tried ADezii's approach, which nearly worked, but I got :
s
et
y
B

The approach can work, I'm sure, but is a little restrictive on control size.

I'm curious to know why a simple vertical display of the text is not visible suddenly :S
Have a look/see, NeoPa.
Jul 17 '08 #9

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Taha Zayed | last post by:
Has anyone know how to change direction of cross-tab report to be suitable for Arabic
7
by: hawat.thufir | last post by:
Given an xhtml file, how can I "export" the data to plain-text? That is, I want: google www.google.com Whereas, if I copy and paste what the browser shows, I lose the URL and end up with:...
1
by: Santosh | last post by:
dear all i want to change text direction of text box with in datagrid control i am writting following code but it is not working. public void SetUpClientScript(object sender,...
1
by: novie | last post by:
I have an Oracle report and I am using the Down/Across Print Direction, for only a section of the report. I have A query that is used to select the students and then those ids are passed to a nother...
4
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post by:
I have created a report. This report needs to display records between two dates entered by the user. I put two text boxes on the report so I can enter the start and end date - I set them to use an...
5
by: dm3281 | last post by:
Hello, I have a text report from a mainframe that I need to parse. The report has about a 2580 byte header that contains binary information (garbage for the most part); although there are a...
12
by: Keith G Hicks | last post by:
I have a client that I wrote an MS Access app for quite a few years ago where they need to know the height in inches of a block of text for billing their customers. The MS Access app opens Word in...
4
by: J Lagos | last post by:
I want to change the backcolor of textboxes in a report depending on their value. I messed with this for a few hours but I'm not savvy with the syntax for getting at controls in a report. can...
11
by: JWest46088 | last post by:
I'm having difficulty trying to figure out how to print a text file from a hash table one line at a time. I have the text file read into the hash table and can print the text file all at once, but I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.