I have a unlinked combo box which has a source file based on a row in a table
but I cannot group the data as it insists on showing all of the records in
the table even if only select the one field as if the *(select all) field is
there whether I like it or not.

This code works great, BUT i want the form to close or be read only if the
[Job Completes] equals null
Do I use else??
Private Sub Form_Unload(Cancel As Integer)

Is this possible? I have loads of text in a label on a form, but would prefer
to make the label smaller and therefore need a vertical scroll bar, but there
is no option for this.
Do I need to insert something else and copy the text in to get a scroll bar?

XP Pro Office 2003
Is there a way to print the switchboards and their entries in a list such as
a table of contents?  The Documenter does not appear to do this.
Thanks

I would like to make a form that has a combo box with a check list option to
select the desired items that I want from the drop down list.
I would like to have an option to "Select All" or Select Multiple ones by
manually putting a check in a box in front of the item.

I have a query that looks at two boxes on a form one is linked directly to a
table the second is a lookup which brings back detail form anther table.
The first box is working but the query is failing to pickup the unlinked
list box.

I am looking for some coding assistance. I have a tab control called "Master
Tab" with 3 tabs on it called "Type" "CIP" and "Vacuum".
When I load the tab control form I want "CIP" and "Vacuum" to be hidden -
only "Type" should be showing.

I am trying to error trap on a subform so after a date is filled a set number
of fields on the same record line need to be filled in otherwise the box will
be cleared and the required fileds highted in red.  
I have achieved this for when on a single view form but cannot when ...

I am going to give you a brief description of my dilema. First of all I am
using Access 2000, I am very new to it and am building an entire database on
my own for a new job.
I have most of the database done (tables, queries, reports) and I created a

Is it possible to tweek the text alignment in a combo box other then
the standard "Left-Right-Center" preset options ?
Thanks - George

Last week I posted regarding synchronizing two different forms.  I have 2
main forms with subforms.  Form 1 is a doc form with pt listed in a subform.  
Form 2 is a pt form with docs listed on the subform.  I would like to have
the ability to place my cursor on the doc form's ...

Is there a way to change the text size and color of a ControlTip Text
property?  I can't find anything on it.  The same question applies to
Valadation Text.  I know I can use Conditional Formatting in some instances
to achieve the same thing.  

I have a view in SQL server which will have a variable number of columns; I
want to be able to dynamically create an Access form based on this view so
that the form will pick up the new columns.
Any ideas?

This is a slightly different question than my last.
I have a Continuous View subform designed to look like a Datasheet View
subform, with the following fields:
Units

I have a Select Distinct Look Up query to display the "Actor" names, but for
whatever reason when I select one of the records the combo box will not hold
the selected record.  It's as if it were to reset itself.  Also, once I have
made my selection what code do I need to use in ...