Yes/No Format Issue

C

CJ

Hi Groupies

I have been building databases for years and have not run into this problem
before.

This 2007 database I am working in has a few yes/no fields.
When I add these fields to a Form, they are show up as
textboxes instead of the yes/no check box I am expecting.

They respond correctly in queries, autoreports and autoforms but
when I add it manually, I get Yes or No and have to manually
change it to a Check Box

Any ideas? Anybody else having the same issue?
 
G

golfinray

A couple of thoughts: 1. Is the form editable? 2. Have you checked the table
properties on those yes/no fields?
 
C

CJ

Yes and yes.

It's odd, it's not just one table in this one database, it's any table in
any
database that has a yes/no field. It's not the end of the world but it
is extremely annoying.

It's almost as if an Office update messed up the code somewhere.

--
Thanks for taking the time!

CJ
---------------------------------------------------------
Know thyself, know thy limits....know thy newsgroups!
golfinray said:
A couple of thoughts: 1. Is the form editable? 2. Have you checked the
table
properties on those yes/no fields?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable and Lock All Feilds wiht a check box 2
Format Yes/No in Union 4
Yes/No Box 5
How Do I display a Yes/No Field correctly in a List Box? 2
Yes/No fields and code to uncheck a default "yes" box if another yes box is checked 5
Yes/No field in combo box 3
Converting a field from Yes/No to Text Box not changing in a form 3
Yes/No Prompt 3

Top