How do I compact check box labels?

  • Thread starter Thread starter BabyATX13 via AccessMonster.com
  • Start date Start date
B

BabyATX13 via AccessMonster.com

I have a form that has multiple check boxes on it, and the report is based
on the form.
I can display only the information that is checked on the form in the
report but the information is not always on the same line or there is too
much space between the labels.

Example (what report looks like)

Bread, Water,


Eggs.


Example (what I want report to look like)

Bread, Water, Eggs.

How can I fix this?
Please help.
Thank You,
KB
 
What do check boxes have to do with Bread, Water,...?
Do you have table structure(s) that you might like to share?
 
I have a list of items in a table, kind of like a store list, if the box is
checked the item should appear on the report if not it should not appear on
the report. I was able to do this by listing all of the items in the table,
with a check box, in the report, and with VBA I can make the report show
only what is checked. My problem is they are not all together in the report
like I want them to be, per the earlier post. I want to know how to do
this, one way or another.

Thanks
KB
 
KB,
Apparently you didn't understand my request:

"Do you have table structure(s) that you might like to share?"

I think your database "commits spreadsheet". However, it is difficult to
make assumptions since you don't provide information that is requested.
 
Duane,
No apparently I don?t have a clue as to what you are talking about. I tried
to describe my table to you; I don?t know how to be any clearer, but let me
try again.

I have a list of items in a TABLE, kind of like a store list.
These are ALL check boxes.
For every RECORD a different series of boxes will be checked.
So for every RECORD I need to show what boxes have been checked to be shown
in a report.
That I can do, but the report LOOKS like crap. I want the report to look
like it was typed in word, without having to type it in word.

Thanks
KB
 
When anyone asks about your table structure, they generally mean the field
names and types. I think in your case, this would be:
tblItems (table name)
==========
ID autonumber primary key
Bread yes/no
Water yes/no
Fruit yes/no
.... yes/no

Does this describe your table structure? If so, you should read some
information on normalization. There are ways of normalizing this type of
"spreadsheet" table using a union query.

Your initial question can't easily be answered without understanding your
table structure (see above) and maybe some sample data.
 
Then I would suggest you normalize your table with a union query.
SELECT ID, "Bread" as Item
FROM tblItems
WHERE [Bread] = -1
UNION ALL
SELECT ID, "Water"
FROM tblItems
WHERE [Water]=-1
--etc through other fields--
You can then base your report off the union query.

If you get the table structure correct, the reporting becomes much easier.
 
OK I made my Union Query. now how do I get the information in a report
without making it look like a list?
 
I did the union query, and all of my information was out of order when I
put it in my report, and it was all in columns. This was not exactly what I
wanted to do, but it was closer than what I had before.

So I changed my mind, since all ITEMS are unique the
Table structure is now:
Field Name Data Type
===========================
Item Text
===========================
The above table will be used as a lookup table only, for the following
table. The following table will be used for a subform in an invoice form,
where child and master fields are linked through InvoiceNo.

Structure:
Field Name Data Type
=============================================
ItemNo Autonumber primary key
InvoiceNo Number
Item Text
=============================================
From this table I am running a sub report, that only lists the ITEMS in the
table for each invoice number. The items are listed in 6 columns with
..0056? spacing between them, however, it still looks like it is in columns
and I don?t want it to look that way. What can I do to make it look like it
is in paragraph form?



Thank you,
KB

P.S. Since the Invoice table is not relevant to my problem I did not list
it.
 
You should be able to use the concatenate function within a query of your
Invoice table
AllItems: Concatenate("SELECT [Item Text] FROM [The Following Table] WHERE
[InvoiceNo] = " & [InvoiceNum])
 
Back
Top