Hi.  I'm having a problem in my function getting the correct msg box to
appear.  One of the discussion group members suggested using:
If Like2(strZip, "@#@#@#") Then
No idea what Like2 is.  I'd appreciate any insight as to why my code isn't

I have a form field where I want the field to display as blank (no zero) in
it for initial data entry. However, the underlying table has a default value
of 0 in it for that particular field and I want to keep it that way. What
edit mask can I use so that the "0" does not display ...

My database has a Master Menu (not created with a wizard)  There are command
buttons to call other forms & reports.  (I use macros for this)
I am trying to devise a way, using Visual Basic,  to change the properties of a
form when that form does not have the focus.  Specifically- ...

HI TWIMC,
I'd like to be able to set the database property "Show Hidden Objects" to
False via code. It should be something like
CurrentDb.Properties("StartupShowHiddenObjects") = False

To help you understand my problem and assist me, I will give an actual
illustration. I have a table that consists of CustomerPhone, Name, Address
etc. The customer Phone is a PK. I have created a form with unbound text
fields. Once a user enters the customer phone and clicks on ...

I have set up a Find Records form for search the records listed in the table.
I have setup text boxes for searching the information with a Find Records
command button. I have also set up a command button called "Clear List". What
I am wanting is to clear the records in the list ...

what practical difference is there in using lostfocus or on exit besides the
cancal param?

Have a parent form (frmWebEvent) that loads a specific event based on a key
field (zEID).  I have two list box controls on the form that need the be
restricted to reflecting just those items based on the key.  When I specify
zEID=[forms]![frmWebEvent]![zEID] in the list box row ...

i can cler the listox selection by  setting it to "" or null, but the first
row is hilited.
how can i make the hilite go away?

I have an event with this code:
   picture1.Visible = True
   Lbl_Waiting.Visible = True
  ' Beginning the query to populate the List

Can anyone give me a simple example of subclassing a control, for example a
message box?? to add some functionality (anything)
I would like to get more into OO concepts...

I am building a continous form and i would like to have an area that the
user can "double click" and have the event bring up a data entry form
To give a little background i am creating a change order database where i
have a form that enables the user to create and print a change ...

Need a little help here.  
Using A2K, I have a combo box on a form that contains a list of about 20
"tasks" than can be selected on some of the tasks I am having a detail form
open up, depending on which one is selected.  For example, If I select New

I am using access 2000 on xp.
I have a main form with a subform whose underlaying table is the LLPG(land
and property gazeteer) which is list of all properties within a local
authorities boundary. This is set information that I cannot change. This form

I see a lot of posts here about combo boxes, but have not quite found my
problem yet...  I swear I have seen this before, and I may even have used
this before, but cannot for the life of me find it!!!!
I have a combo box that fills according to a row source UNION query so that