By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,160 Members | 1,031 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,160 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.