I have a form with a list box and when I Enter the listbox by tabbing from
the previous object I want the first item to be hightlighted.  The listbox
has records but currently the first record is not highlighted.  I was trying
something like this in the ON ENTER event:

I've got a yes/no field in a data base which is linked to a checkbox on a
form.  Now I would like to change the color and size of a label dpending on
the value (0 or 1) of the data.  I've written the subroutine, but can't seem
to get it to run when the database record is changed. ...

I setup a Purchase Order table and form to keep the Purchse Order database
for accouting. And we want the system to assign the PO number as autonumber
but starting from 2000 not 1(because 1-1999 already used and want to keep
reality consistent), how can I do that?

I have a form with a Command button.  What I would like to have happen is
when this command button is clicked, a value (i.e. 1) would be
input(assigned) into a field in a table.  The code I have is as follows:
Private Sub Command0_Click()

I have this form that is 8" by 10", it is designed as two service request
"forms" and has been printed on a standard letter size paper.
It normally works correctly.
But now it is printing on two sheets splitting the two service requests one

My clients are encountering errors on applications which have been in place
for years, and seem to be increasing as I make changes.  The errors are
unrelated to the changed, for example if I change the caption on a label the
form bombs out.   This is happening on different sites on ...

When customers call us we always get their phone number but not always their
town. There are about 12 towns in the area and all use the same area code. I
was thinking of doing a select case statement based on the prefix that when
the phone number is entered, the town would fill ...

I have a Y/N combo box on my form. If the answer is "N", then I would like
to show the label next to; otherwise, hide it.
I checked the "Conditional Format". It seems it works only on the combo box
itself.

What I am trying to do is print a file. In the application I need to confirm
the existance of a file give only part of the file name. Then I need to print
the file. This is from within MS Access.
Thanks in advace.

I have a parent form which is tied to a table of inspection data.  I have a
subform on that parent form which is tied to the serial record for the
inspection.  Here's my problem.  I have the relationship set up so that the
primary key, SerID, from the serial record is on the ...

I have a tab control on a pop up form (frm_NetRequirementsTab) with 3 tabs:
Operator (NetReq_NetTypeID=1), Maintenance (NetReq_NetTypeID=2), and Trainer
(NetReq_NetTypeID=3).  This pop up form is called from a command button
(cmdNetReq) on the main form (frm_System).  Each tab ...

Is it possible to change the background color and font of a Msgbox/InputBox.
I've coded several Msgbox/InputBox's in my database but would like to change
the standard gray color.  Or is the only way to create a form, instead of
using the Msgbox/InputBox function?

This sounds simple, but it's not working.
I have (2) forms in a database, and one module titled "Results." .  There
are (2) Private Sub Procedures in the Module.  Clicking a button on one of
the forms calls the first procedure in the module, and it works, no problem.  

I have a database with records that include a date in the
future.  Is there way to "lock" the record once that date
occurs so that users can no longer update fields?

I have a form with an unbound textbox and a listbox.  I want to requery the
listbox object with each keystroke in the textbox.  The listbox's record
source is a query that has a criteria in the ClientName Field of -- Like
ReturnValue().  ReturnValue() should return what is ...