how do you get "Format/Size/Size to Fit" the text box field will not autofit
up and down in size with the text that is entered in the given field.
What am I missing?

I'm lookng for some help with updating a value in a form when a subform
total changes ?
I have an order form which contains a subform containing several line items,
and there is a control on the subform which

The property field  Allow Form View is set to yes, but when I switch from
Design View to Form view no fields are displayed.  ???

Is there anyway to prevent a scroll mouse from scrolling through records on a
form?  I set the "Cycle" property to the current record, but that did not
work.  It becomes a big problem when you have a sub-form.  If I am in the
sub-form and I use the scroll mouse, it advances the ...

I have a report that lists individual locations associated with single data
(such as a region).
Does anyone know how I could get these locations to list horizontally rather
than vertically in order to save significant amounts of space?

When a filter has been applied, I would like the detail background color to
change so they know they are looking at a filtered dataset.  I tried the code
below, but all that changes is the filter by form screen BEFORE they apply
the filter.  I need it to change color after they ...

I have a new field in my Table that i need in my form
there are no queries
the new field does not show up in my field list.
i have tried to add a text box and set the properties data control source to

I have access 97. I have 2 forms that when ever I try to change the tab index
it changes to some random number. Example: I have 8 fields on this form. I
change the first field to "0", Then the next field to "1", then the next
field to "2", but when i click for the next field it ...

MS Access 2000, Windows XP
I have created a form from a query which seraches for a member of a club and
created my main form. I have then created two other queries.
Rental query and Video query

We are doing testing on a ms access 2003 database.  It requires registration
of a 3rd party dll file.  However, when the db opens on another computer, the
dll is "MISSING" and must be re-registered, even when it is in the same
folder location.

Have a textbox on a form with the control source of a memo field.
When I open the form all the text is highlighted (selected), which could
cause a problem if the user just starts typing.
How can I deselect the text and go to the last line of when the form is

I have a table with 2 fields WS and WG.  I need to create a form that allows
the user to enter in the WS number and its corresponding WG number will
populate in its field.  How do I create this?  I have created a combo lookup
box for the WS, but it only moves to the next record ...

I would like to setup a dropdown list of report names which when selected run
the specific report.
I am guessing that i need a form with a text/combo box on it but cant seem
to figure it out from there

Does anyone know, (when dealing with a long list of items on a subform), how
to position the 'view' so that the new record, and last few entries remain in
the view. After adding a new row the view goes to the top of the list and I
have to scroll to the end to add another record.

How do I change the default spacing between these two items (they are too
far apart).
Also, is there any way to 'unbind' them short of flat out deleting the
label?