I need a check box in a form to be checked off. How can I do this? Can
someone please help me.

I have a form that sits straight on top of a table. I enter new records
by hitting the ">*" button for a new record and then filling out the
fields.
Can anyone tell me when this record will appear in the actual table?

I have an Access project that is obviously tied to a SQL Server d/b.
On one of my forms I show a datetime field - for product introduction
date.  When I create the record I initialize the field to the default
date of  01/01/1900.  Is there anyway I can prevent this date from

When making a field datatype CHAR in SQL Server for my Access project I
found out that you always get trailing spaces in a bound textbox on the
form.  In order for a user to enter anything they must first back out
the trailing spaces.  I tried trimming the data first in the On Click

Using Office 2003 with Windows XP;
I choosing between the use of:
1) Multi-column listbox; 2) Sub-Form; and 3) Continuous Form
Which one is generally considered all around to be: most stable and most

I have two fields in my table: Date Received And Date closed. I would like a
Date Diff on my form to show how many days I have had something if the Date
Closed field is Null (ie not closed). I have a field to show how many days
between received and closed but how many days open ...

Our management form would not allow any text to be edited for any field on
the form regardless of whether the field was locked or not.  I had found a
way to bypass this by moving the fields to another form and selecting from a
renamed table and renamed query with rebound fields. ...

I need help...
I have a query that has two fields that calculate dates.  I need to pull
entries that fall between those two dates only.  I have used BETWEEN, >=,<=,
and I don't know where else to go.  Here is the example that I am talking

I have added a text box in the footer of a subform to total all the line
costs.  My subform is a datasheet view, but it does not show the Total Cost.  
When I go into design view, my design is there, but when I go into form view
it is no where to be found.    Any help would be ...

I have a subform that has a various field(checkbox) & a count field(text box)
both are bound. The user goes in, selects their order # & puts in their
information in the fields mentioned above, then clicks the preview button and
gets the report. What I need is to clear these 2 fields ...

I'd like to find a way restrict my forms design to a specific pixel count so
I know it will fit correctly on different display formats.
Ideally, I could just set the ruler to display in pixels.
I know I could just switch my resolution back and forth but there should be

Here's my problem, I have the combo box set up for the notinlist and that is
working just great.  I can bring up the add new form and be able to enter all
the data that's required.  Now here is where I get lost, when I exit the add
new form and come back to the original screen I ...

I want to only enable a save button when a record is either added or altered.
I have been able to use the me.dirty event to enable the button when changes
have been made on a single form but this does not seem to work on a continuos
form.   ( the continuos form is a subform on a ...

When using the vertical scroll bars to scroll down on my form, the top
of the detail section dissappears under the header. Is this normal -
and can I prevent it?
Stapes

Thanks for all of your past help.
I bet I stump you on this one!!!! How do you display two fields in a
combo/list box?
Specifically, I have a combo box that has several fields of data associated