Don't want to print blanks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!!!!
 
Well I tryed to Concatenate inside of a quiry, but the problem still is
there. What am I doing wrong.
Help please! Thank You!
 
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
 
Back
Top