Forms & fields help with Access

[Julie B]

I am creating a form and when putting the fields in design layout, there is a
fixed field and the field that is to be filled in. In one of the fields it
allows me to place the fixed field, but there is a box with a check mark, and
it doesn't create the box that gets filled in with data. I think it may be a
setting of some sort, but am very new to access and cannot figure it out.
Can someone please help

Julie B

 

[Wayne-I-M]

I "think" (may be wrong) that you seeing the Field (the control linked to
your table field) and the Field Lable (your fixed field)

You can delete the lable (name) if you want.

I don't understand this bit

In one of the fields it
allows me to place the fixed field, but there is a box with a check mark, and
it doesn't create the box that gets filled in with data.

Can you explain it in some other way ?

 

[John W. Vinson]

On Sun, 19 Oct 2008 04:45:00 -0700, Julie B <Julie

I am creating a form and when putting the fields in design layout, there is a
fixed field and the field that is to be filled in. In one of the fields it
allows me to place the fixed field, but there is a box with a check mark, and
it doesn't create the box that gets filled in with data. I think it may be a
setting of some sort, but am very new to access and cannot figure it out.
Can someone please help

Julie B

STOP.

Designing your forms first is like installing the windowpanes and frames in
your new house before you decide where the foundations will be poured!

Forms *are secondary*; they're just tools to manage data stored in Tables.

Get your table design correct first, and THEN work on the forms.

See the following, especially the last two tutorials:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[Julie B]

I am creating a form is deisgn view. When I take the control for a field and
place it on the form, all of my fields but one show up as 2 fields really,
one that is grayed out and the other data text box, that will allow me to
enter data. So in other words, one of the control fields doesn't have
another place to enter the data. Not sure if it is a setting or what, I have
tried just about everything. Hope that explanation helps I am not very
computer literate with this program

 

[Larry Daugherty]

As Wayne wrote, the "other" control is the *label* associated with the
control that behaves as you expect. With the label selected, turn on
the properties and you'll find a field on that dialog box named
"Caption". Put your cursor in that field and you'll find that you can
change the text in that field. When you change back from design mode
to run mode you'll see your new text in the label. Or, as Wayne
suggested, while in design mode you can select the label and hit the
delete key to delete it.

It seems that you're as the start of the beginning of learning to
design with the Access interface tools. You might find books like
"Access [any version] Getting Started" or even "Access for Dummies".
Those books will have some of the fundamentals that other books assume
you already know.

HTH