I had a similar problem. What caused it was Infopath was reading the list items from a view, so it was limited to 20 items. I created a new view that had no limit on the number of items per page, used that view to access the items for the drop down box and it fixed the problem.
Fadi ________________________________ From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Paul Turner Sent: Monday, 2 March 2009 12:00 PM To: ozmoss@ozmoss.com Subject: RE: limit on drop down boxes in infopath? Yes, there is a limit. Regards Paul Turner Senior Solution Specialist M: 0412 748 168 P: 08 8238 0912 F: 08 8234 5966 A: 66 Henley Beach Road, Mile End SA 5031 E: paul.tur...@sdm.com.au W: www.sdm.com.au <https://adlex01/exchweb/bin/redir.asp?URL=http://www.sdm.com.au/> ________________________________ From: ozmoss@ozmoss.com [ozm...@ozmoss.com] On Behalf Of Nigel Hertz [nigel.he...@stockland.com.au] Sent: Monday, 2 March 2009 10:45 AM To: ozmoss@ozmoss.com Subject: RE: limit on drop down boxes in infopath? Make sure you don't have "illegal" characters in your resultset. Infopath dropdowns don't seem to like them (ampersand being a classic example) From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Chris Grist Sent: Monday, 2 March 2009 10:59 AM To: ozmoss@ozmoss.com Subject: RE: limit on drop down boxes in infopath? Haven't got that far yet, its still just in InfoPath its self Cheers for that, looks like it's a sql query problem, although all the rows are in the DB there not being returned, will look into that. Chris Grist Technical Officer, ICT Systems Education.au Limited Level 1, 182 Fullarton Road DULWICH SA 5065 p +61 8 83343291 f +61 8 83343211 e cgr...@educationau.edu.au w www.educationau.edu.au <http://www.educationau.edu.au/> From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 2 March 2009 10:22 AM To: ozmoss@ozmoss.com Subject: RE: limit on drop down boxes in infopath? There certainly shouldn't be. Where's it bumming out? How many items? Is there a pattern, is it random, or is it only loading the first part of the list? Have you checked the page source to see if all the items are there but just not being displayed? If this is the case then it's just possible a CSS height property has been applied to the select element. This would be totally whack but wouldn't surprise me. From: ozmoss@ozmoss.com [mailto:ozm...@ozmoss.com] On Behalf Of Chris Grist Sent: Monday, 2 March 2009 10:48 AM To: ozmoss@ozmoss.com Subject: limit on drop down boxes in infopath? Hi Guys, Im using a data connection to dynamics sl to get a list of projects to put on a form. However, it seems that only about 50% of the projects are displayed. Is there a limit on how many items can be in a drop down list box? Chris Grist Technical Officer, ICT Systems Education.au Limited Level 1, 182 Fullarton Road DULWICH SA 5065 p +61 8 83343291 f +61 8 83343211 e cgr...@educationau.edu.au w www.educationau.edu.au <http://www.educationau.edu.au/> ________________________________ IMPORTANT: This e-mail, including any attachments, may contain private or confidential information. If you think you may not be the intended recipient, or if you have received this e-mail in error, please contact the sender immediately and delete all copies of this e-mail. If you are not the intended recipient, you must not reproduce any part of this e-mail or disclose its contents to any other party. This email represents the views of the individual sender, which do not necessarily reflect those of Education.au except where the sender expressly states otherwise. It is your responsibility to scan this email and any files transmitted with it for viruses or any other defects. education.au limited will not be liable for any loss, damage or consequence caused directly or indirectly by this email. ________________________________ Support procedure: https://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: http://www.codify.com/lists/ozmoss <http://www.codify.com/lists/ozmoss> Other lists you might want to join: http://www.codify.com/lists <http://www.codify.com/lists> ________________________________ Support procedure: https://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: http://www.codify.com/lists/ozmoss <http://www.codify.com/lists/ozmoss> Other lists you might want to join: http://www.codify.com/lists <http://www.codify.com/lists> ________________________________ IMPORTANT: This e-mail, including any attachments, may contain private or confidential information. If you think you may not be the intended recipient, or if you have received this e-mail in error, please contact the sender immediately and delete all copies of this e-mail. If you are not the intended recipient, you must not reproduce any part of this e-mail or disclose its contents to any other party. This email represents the views of the individual sender, which do not necessarily reflect those of Education.au except where the sender expressly states otherwise. It is your responsibility to scan this email and any files transmitted with it for viruses or any other defects. education.au limited will not be liable for any loss, damage or consequence caused directly or indirectly by this email. ________________________________ Support procedure: https://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: http://www.codify.com/lists/ozmoss <http://www.codify.com/lists/ozmoss> Other lists you might want to join: http://www.codify.com/lists <http://www.codify.com/lists> ________________________________ Stockland Notice: If this communication has been sent to you by mistake, please delete and notify us. If it has been sent to you by mistake, legal privilege is not waived or lost and you are not entitled to use it in any way. Stockland and its subsidiaries reserve the right to monitor e-mail communication through its networks. ________________________________ Support procedure: https://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: http://www.codify.com/lists/ozmoss <http://www.codify.com/lists/ozmoss> Other lists you might want to join: http://www.codify.com/lists <http://www.codify.com/lists> ________________________________ Support procedure: https://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: http://www.codify.com/lists/ozmoss <http://www.codify.com/lists/ozmoss> Other lists you might want to join: http://www.codify.com/lists <http://www.codify.com/lists> -------------------------------------------------------------------------------- Support procedure: http://www.codify.com/lists/support List address: ozmoss@ozmoss.com Subscribe: ozmoss-subscr...@ozmoss.com Unsubscribe: ozmoss-unsubscr...@ozmoss.com List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists