Request help with the yes/no toggles

[Vicki.5280]

I'm very new using Access, having just "discovered" it about 3 weeks ago.
This is the second time I've tried to create this particular form. I'm
trying to use the yes/no toggle box, for three fields, however the boxes
themselves are too small and don't look right in the form. Is there any way
to make them larger in the form, but carry over to the data sheet as a text
yes/no?

I know nothing about using the Expression Builder, so if that's involved,
I'll be better off either sticking with the tiny boxes or just switching back
to text.

I appreciate any help!

 

[Vicki.5280]

I forgot to add that I'm using Access 2003. Thank you.
:
I'm very new using Access, having just "discovered" it about 3 weeks ago.
This is the second time I've tried to create this particular form. I'm
trying to use the yes/no toggle box, for three fields, however the boxes
themselves are too small and don't look right in the form. Is there any way
to make them larger in the form, but carry over to the data sheet as a text
yes/no?

I know nothing about using the Expression Builder, so if that's involved,
I'll be better off either sticking with the tiny boxes or just switching back
to text.

I appreciate any help!

 

[Ben Robson]

ya

 

[BruceM]

If you are just three weeks into this you may find the following tutorial
helpful:
http://allenbrowne.com/casu-22.html

There are more tips here, as well as a Links link on the right side of the
page: http://allenbrowne.com/tips.html

These are just two of the many resources out there.

In general any discussion of a database starts with the design, which is to
say the database's purpose, and the table structure and relationships. Once
that is established you can begin thinking about the user interface and how
the data are presented to the user. Tables are for storing data; queries
are for arranging the data and perfoming calculation, forms are for working
with data, and reports are for viewing data.

Having said that, in response to your specific question you can change the
size of controls (text boxes, combo boxes, toggle buttons, and just about
anything you can put onto a form) by dragging the edges. You can choose how
to view a Yes/No field (check box, text box, combo box, toggle button,
option group), but in any case you should not be thinking about viewing the
data directly in the table. A table looks sort of like a spreadsheet, but
it is entirely different. The display format in a table is not especially
relevant to how the data are displayed on the form, although setting the
format and appearance in the table (table design view, General tab and
Lookup tab) will affect the default appearance when you drag the field from
the field list to the form.

The Expression Builder is for constructing expressions such as mathematical
operations for use in text boxes. I have never had much use for it, but
maybe there is a way of using it that makes sense but that I have not
discovered. I don't think it particularly relates to your question.

If a lot of this sounds foreign, check out the tutorial. It will make a lot
of things much clearer, and will be well worth the time it takes to read it.