A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I have multiselect list box to show values in report?



 
 
Thread Tools Display Modes
  #1  
Old November 24th, 2005, 05:57 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old November 24th, 2005, 06:05 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old November 24th, 2005, 06:07 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old November 25th, 2005, 02:23 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Reporting subreport total on main report BobV Setting Up & Running Reports 22 November 1st, 2005 04: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 12:20 PM
Only show 'yes' values in a report Matt General Discussion 2 January 18th, 2005 03:59 PM


All times are GMT +1. The time now is 08:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.