Hi Kevin,
>2 problems;
>
>Whenever a I create a Drobdown List with a RowSourceType of 1, and put say, 2 values in it (Y,N) I always get a 3rd item with just a space in it, until I've selected Y or N.
>
>I also want a combo box to default to the value "N" whenever it has no entries in it's RowSource - or should I stick to using the Database Container to issue a default value to the table itself.
>
Both your problems have an easy solution: just put thisform.cmbMyCombo.DisplayValue='N' (in design time or in Init method of your combobox). It should eliminate empty string and the default value would be 'N'.
Then you can bound your 1 character field to this combobox.
If this field allows only 2 state: Y or N you can try checkbox, as Mike suggested, but you should do some manipulations...
If it's not broken, fix it until it is.
My Blog