If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I have multiselect list box to show values in report?
I have a multiselect list box in a form, where I can choose items in a list.
I can't seem to have it show in either a query or a report? Help, please! |
#2
|
|||
|
|||
How do I have multiselect list box to show values in report?
Vanderzee wrote:
I have a multiselect list box in a form, where I can choose items in a list. I can't seem to have it show in either a query or a report? Help, please! Have WHAT show? If you are trying to use a multi-select list box as a bound control to save data into a table that will not work. As it is a violation of proper database rules to store multiple values in a single field a multi-select ListBox always has a value of Null. The only legitimate use for these is in a code routine where you need to do something with the selected values. In VBA code is also the only place where you can retrieve the selected values from a multi-select ListBox by looping through the ItemsSelected collection of the control. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
How do I have multiselect list box to show values in report?
See:
Use a multi-select list box to filter a report at: http://allenbrowne.com/ser-50.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Vanderzee" wrote in message news I have a multiselect list box in a form, where I can choose items in a list. I can't seem to have it show in either a query or a report? Help, please! |
#4
|
|||
|
|||
How do I have multiselect list box to show values in report?
There is also a sample generic function for this at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. I wouldn't use this function for tables with 10s of 1000s of records. -- Duane Hookom MS Access MVP "Allen Browne" wrote in message ... See: Use a multi-select list box to filter a report at: http://allenbrowne.com/ser-50.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Vanderzee" wrote in message news I have a multiselect list box in a form, where I can choose items in a list. I can't seem to have it show in either a query or a report? Help, please! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
Urgent! Help! Show 0 values in query or report | JoHickey | Running & Setting Up Queries | 5 | October 4th, 2005 09:13 PM |
How can I only show part of a list in a report? | Mike | General Discussion | 3 | August 16th, 2005 11:31 PM |
How do I make values from a table show up in a drop down list on . | Printing Field Name List | New Users | 3 | February 9th, 2005 11:20 AM |
Only show 'yes' values in a report | Matt | General Discussion | 2 | January 18th, 2005 02:59 PM |