InfoPath Dev

I have several dropdowns in my form which are prepopulated from a Sharepoint list.....   some of the columns in the Sharepoint list are longer than the others.......meaning they have more data.....  but it seems that the dropdowns are looking at the dropdown with the most data and putting blanks there which can make for a long dropdown with white space..... 

 How does one limit items to actual data and NOT blanks or white space. 

 Also, why does the scrollbar in the dropdowns start at the bottom and we have to scroll up to see selections?

I tried setting the default for the field by following these steps but it didnt eliminate the blanks..:

 1. Double click on dropdown field in the data source.

2. Select Fx button for Default value.

3. Select Insert field or group.

4. Select secondary xml from data source.

5. Select “value” and click on ok.

Chris

HI there,

Need a little more detail on why your dropdown contains blanks.  Could you elaborate on what you mean by dropdowns are looking at the dropdown with the most data?  Is your dropdown connected to just one SP list or more?

Perhaps if you can include a screenshot that would be great.

attached is the SP list i am using for my dropdowns.... yes i am using just one SP list.   see attachment.....

will send a second post with the dropdown list pic so you can see the white space....

c

attached is one of the dropdowns.....  you will notice the white space after the choices that some from the SP list.