List Boxes

[Gary McQuigg]

I've been given an Access Database with a table.

It appears someone tried to do a calculated field within the table
(redundant data and didn't work).

My quick? solution was to:
query the table
replace the field with a calculation, in the query, that does work
print a report.

Problem with various list boxes.

I get a report with the selection highlighted amid the rest of the choices
from the list boxes.

Is there anyway to return only the selected items, from the list box field,
in the
query?

MyTable
Field Name = Text
Display Control = List Box
Row Source Type = Value List
Row Source = "Name1";"Name2"

 

[Piet Linden]

I've been given an Access Database with a table.

It appears someone tried to do a calculated field within the table
(redundant data and didn't work).

My quick? solution was to:
query the table
replace the field with a calculation, in the query, that does work
print a report.

Problem with various list boxes.

I get a report with the selection highlighted amid the rest of the choices
from the list boxes.

Is there anyway to return only the selected items, from the list box field,
in the
query?

MyTable
Field Name = Text
Display Control = List Box
Row Source Type = Value List
Row Source = "Name1";"Name2"

if it's a multi-select listbox then you need to set the Row Source
property in code because you cannot create a delimited list like that
in a query.

one of these articles should solve your problem:
http://www.mvps.org/access/reports/rpt0005.htm
http://www.mvps.org/access/forms/frm0007.htm