Don't want to print blanks

A

Amour

I am new so please understand.
I have a report with 8 different textbox's (unbound) inwhich it checks for
information and places an X in the textbox(s). I first put all in the name
header, but would only receive one X per name(record). So I put all
textbox(s) in the detail part and it worked for the X(s) exspect that I am
getting blank lines when there is no X(s). I used the can shrink, in both
the Detail section and each textbox in that section, but it still shows up
with the blank lines and waste to much paper. Please if anyone has
solution... Thank You!
 
A

Amour

Right now the report looks like:

A B C D E F G H
John smith X
X
X
X

X
X
X
Joe Smith





X



I would like it to look like:

A B C D E F G H
John Smith X X X X X X X
Joe Smith X
and so on:

Please can someone help
Thank You!!!!
 
A

Amour

Well I tryed to Concatenate inside of a quiry, but the problem still is
there. What am I doing wrong.
Help please! Thank You!
 
K

kew

Write all the values out to one txt field

a=1 'col1

Put this in the detail section of the report

'qry - buffer the col_text
a=0
do while a< 8 'number of columns

if isnull(col_text) then format_text=" "

total_text=total_text & format_text & " "
a=a+1
next col_text
loop

text1.value=total_text
 
Top