Combo Box (these are tricky)

[Mod]

So, i want to set the `row source type' to be a query, and the `row source' to be a simple query like this one

SELECT PrimerPairs.IDPrimerPair FROM PrimerPairs;

But when i use switch to form view, the combo box is behaving oddly. It looks as if the values should be there. When i click on the little drop down arrow, a big empty white box falls down below the combobox, just as if it was populated. but its empty. You can move your mouse down to it, and the rows will highlight. you can click on any of them. but there are no values there.

has anyone ran into this before? it is really freaking me out and i can't figure it.

I've tried restarting access and seen this on two different computers so far.


EDIT
Ok, something wierd is going on with the querys from the form. I tried to change the record source for the entire form, and i got the same wierd results. Does the form need to have any kind of permission to execute queries or anything like that i'm at a total loss.

 

[Mod]

What are your combo box properties set to?

The bound column number of what's that?


Column widths what's that set to ?

The bound column number is `1'

the column widths are :`0";1"'


OH! it was the column width property. Thank you! bleharggg. The first one i created access wanted me to use a wizard and i was like "ok" then i copy and pasted it, and manually adjusted the queries. The original had two

bleh, nevermind, its a long boring story. thanks for the advice.