Combo box and check box showing as textboxes

[zgray]

Today and yesterday I added new fields to a table and they are showing wrong when everything is right. I added yes/no fields and a combo box look up and when I drag them over to my forms they are just showing as textboxes and not a checkbox or combo box. When I look at the backend and look at the fields it clearly says it should be a checkbox or combo box. Iv done it the same way I always have and this time its just wrong. Any Ideas? Thanks.

 

[Mihail]

Today and yesterday I added new fields to a table and they are showing wrong when everything is right.

What means this ? Where are showing wrong ? In the table ?

I added yes/no fields and a combo box look up and when I drag them over to my forms ...

How you drag a field from a table over a form ? Explain, please, the technique, because is first time I heard about. Thank you.

 

[zgray]

In the table in design view if you click on the field at the bottom there are two tabs on the lookup tab it says its a checkbox or combobox. And by drag I mean when you have a form in design view and you drag a field over from the add existing field list.

 

[Mihail]

And by drag I mean when you have a form in design view and you drag a field over from the add existing field list.

I can't find this option in Access 2007.
Any way, design the appropriate control from the toolbar (or from the Design tab in the ribbon) then bound it to the necessary field.
For combos you need to copy the row source from the table to the row source in the form (the SQL).

If you have more questions inform us what version of Access you use.

 

[zgray]

I can't find this option in Access 2007.
Any way, design the appropriate control from the toolbar (or from the Design tab in the ribbon) then bound it to the necessary field.
For combos you need to copy the row source from the table to the row source in the form (the SQL).

If you have more questions inform us what version of Access you use.

Im using access 2010. It may not be in 2007, never used it so idk. And I know I can just grab a new one and bind it to my field im saying it's never done this before and the table design view and design view on the form are telling me two different things.

 

[zgray]

Another thing. If I copy a field that is bringing up the combo box and paste it and change the name. It's still bringing it up as a text box on a form.

edit - It also seems to be working on all my other tables except this one...

edit again - Little more info. My backend table is displaying everything correct when I look at it in datasheet view. But when I open the table in my front end the 3 check boxes and lookup combo box change to textboxes.