Combo Box based on a Query "Available Fields"

[gheyman]

I added a combo box to my form. When building it, as expected, it asks to select a table, query....
I selected a query that I have in my database. But for some reason it only shows two "Available Fields". I have 5 fields in my query. Why is it only showing two as Available?

 

[stumac]

Is 'Show' on the query grid checked for all 5 fields?

 

[gheyman]

Yes, all the boxes are checked and all the fields have data in them when I run the query. The query itself run perfectly.

 

[stumac]

Are any of the fields of Long Text type? Combo boxes didn't used to display them - not sure if this is still the case.

Can you go into the Row Source property of the combo box and add the other columns? (I never use the wizard).