combo shows 0 for value list lookup on new record

[aidan]

I have a table with some combo selections with row source No;Yes, bound column 1, column count 1, and default value "No", limit to list set to yes, required = yes, allow zero length = no.

When I create a new record though, all of the combos show 0, and I have to select No or Yes manually. The requirement is that No is the default value..

Lots of thanks in advance,

Aidan

 

[KenHigg]

Did you set the default in the combo box control?

 

[aidan]

I didn't, no, but I was hoping I shouldn't have to. It's probably just another thing microsoft overlooked I guess.

Aidan

 

[KenHigg]

Kind of screwy sometimes...

 

[aidan]

I've just realised it's based on a query. I suppose this is why.

Aidan

 

[aidan]

got it :

No;Yes = "No";"Yes", but

No = 0, "No" = No.

Stupid me - lulled into a false sense of security by Microsoft again.

Aidan