Why aren't my check boxes showing in my form design?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2000

I have set up 2 tables with about 80 fields in them and am now designing a
form to make data input easier for me. However, the formatting of the last
few fields I created in one of the tables (all check boxes) is not
tranferring to the form correctly.

When I drag the field from the field list onto my form the caption is not
displayed and it is displaying as a text box rather than a check box.

I have compared these fields with others in the table which are similar and
which transferred to my form fine, and I can't see any difference between
them.
It's all very strange. Any help would be appreciated!
 
Thanks for your reply Arvin. I did check the property field and it was set
to check box. However, I kept fiddling with the table and think the problem
might have been too many fields in the table. I deleted loads of fields, then
tried inserting one of the fields which hadn't been transferring properly,
and it worked fine.

There's still space for more fields in my table, but I think the form may
have a limit on the number of fields it holds, and I must have exceeded it.
That's my theory anyway....
 
Back
Top