Connecting Tech Pros Worldwide Forums | Help | Site Map

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

Galina
Guest
 
Posts: n/a
#1: Nov 12 '05
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

Brendan Reynolds
Guest
 
Posts: n/a
#2: Nov 12 '05

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


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" <galkas@mail.ru> wrote in message
news:ecdc865.0402100117.27d88307@posting.google.co m...[color=blue]
> 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[/color]


Closed Thread