473,386 Members | 2,042 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,386 software developers and data experts.

How to print tab in the middle of string in a report?

Hello
I generate a pritty complicate report in my application. The report is
so complicate in fact that I sort and format records in code, form a
long string and assign it to an unbounded field on report. String
presents course(s) information, like course code, location, time, when
it runs and so on. I am asked, is it possible to have tab in front of
course code. Tab and course code are added into the string in the
following simple way:
L = L & Chr(9)
'Add course code and faculty to location
L = L & InstdOfRSet(N, 0) & " - " & InstdOfRSet(N, 10)

The report prints a little rectangle instead of space defined by tab.
I know, how to inserted spaces, so no need to write about it. The
report worked with spaces until now. Now I am explicitly asked to
insert tab, because the report in the form of MS Word text file goes
to typesetting on Mac and the typesetter asks for tab. And it is
interesting to know, why tab character in the string doesn't work, how
it should?
Any help will be appreciated. Thank you.
Galina
Nov 12 '05 #1
1 13646
That square you're seeing is, in fact, a tab character, the Access text box
control just can't display it, and displays all such characters as boxes.

What I'd be inclined to do, if I were faced with this problem, would be to
go back to using spaces in the Access report, and use VBA in Word to replace
the spaces with tabs in the Word document.

--
Brendan Reynolds
"Galina" <ga****@mail.ru> wrote in message
news:ec*************************@posting.google.co m...
Hello
I generate a pritty complicate report in my application. The report is
so complicate in fact that I sort and format records in code, form a
long string and assign it to an unbounded field on report. String
presents course(s) information, like course code, location, time, when
it runs and so on. I am asked, is it possible to have tab in front of
course code. Tab and course code are added into the string in the
following simple way:
L = L & Chr(9)
'Add course code and faculty to location
L = L & InstdOfRSet(N, 0) & " - " & InstdOfRSet(N, 10)

The report prints a little rectangle instead of space defined by tab.
I know, how to inserted spaces, so no need to write about it. The
report worked with spaces until now. Now I am explicitly asked to
insert tab, because the report in the form of MS Word text file goes
to typesetting on Mac and the typesetter asks for tab. And it is
interesting to know, why tab character in the string doesn't work, how
it should?
Any help will be appreciated. Thank you.
Galina

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: neutrino | last post by:
Greetings to the Python gurus, I have a binary file and wish to see the "raw" content of it. So I open it in binary mode, and read one byte at a time to a variable, which will be of the string...
3
by: Simone | last post by:
Hi, I'm a DB newbie and I've been having issues trying to print the record I am viewing in a form to a report. I have looked in groups all over and they all say to try basically the same thing...
1
by: Ray | last post by:
Hi all, Is it possible to print the crystal report directly in vb.net without previewing it? Thanks a lot, Ray
7
by: itm | last post by:
I have a mail out to send to a group of owners with multiple accounts. I want to limit the number of accounts that print on the first page to 20. I want remaining accounts to print on a second...
4
by: Pradeep83 | last post by:
Hi All Can anybody tell me How to print a string name 500 times(or some 'n' number of times ) without using loops ? Thanks In advance' Pradi !
2
by: lekshminair | last post by:
hello friends, can u help me. how to print first string in a line.(before first space) for example: String str={"Hello world java"} output Hello
10
by: amoharir | last post by:
Hello experts, I heard there is a way to print a string in console without using any print statement. (e.g printf, cout, clog, cerr, puts and similar commands) I got a hint to use if...
2
by: RICHARD BROMBERG | last post by:
I have a string variable that is presently being sent to a MessageBox. I want to add a command button to the Form so I can send the string variable directly to the printer. Is there a simple...
12
by: nembo kid | last post by:
How I (recursive) can reverse and print a string (as simple as possible)? I tried with the following code, but it doesn't work. Thanks in advance to everbody. /* Code starts here */ ...
2
by: John Pickett | last post by:
I think this is a really dumb question! All I want to do is print a string! I’ve looked up loads of web pages and they all tell me that Print “string” Or Printer.print “String” should work...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.