Field from Table in a form, changed from a text box into a dropdown

[Fostertrident]

I have fields in a form, they are set as Yes/No, but when I add them into my form they are text boxes which CAN be edited (that's good, I want that) but only in a text box format, which looks quite ugly, is there way of having them as dropdowns?

Many thanks,

[ranman256]

in form design,
click the ADD EXIXSTING FIELDS button
in the controls, select the checkbox control
grab a field, drag it onto the form....it will be a checkbox bound to your field.

[Fostertrident]

That is brilliant, thank you so much, sorks like a charm.