I have a listbox that contains some numeric values like "1","2","3" etc...  
How can I change the what these values display on a form in the listbox?  
What I'd like to do is this: if the value = "1" display "Black"  If the value
= "2" display "Red"  if the value = "3" display ...

hello,
I have a report that shows the detail for 3 different values of a field
named "TransType": (values: pmt, adj, act).
The name, date, and TransType fields are set via a form.  In the report, I

Do you know if it's possible to change the font in a form's subform?  If it's
possible could you give me a few suggestions.  I've inserted a subform but
I'd like my fonts/sizes to match what's on the form.
Thanks Bunches!!!

I have an old vb program (form) that I need to edit/update to work with new
hardware.  Is it possible to "open" a .frm in the vb editor within Access?
Is there a conversion tool?  Migration tool?  All of the tools I have seen
are the other way around...

How can I set up my form that when I execute it that a blank form (template)
shows up and not what is currently in my table.
Please help.
Thanks Bunches!!!!

When I do a macro for a double click on a text box to open a Form B, the form
B opens behind form A. How do I get form B to open ontop of form A?

We have a combo box set up with 2 columns but when we click to make a
selection only the first column is redisplayed.  How do we get column 2 to be
displayed?

I'm trying to set up a form for general quotation information.  I have
general information and I also have a specific Quote Number, but I have
several lines of items to quote.
How would I make my form to allow me to do the following (see example):

Is there a way to have a combo box include a selection in the drop down that
will display "all".  I use the combo box selection to populate the criteria
of a query.  Below is the sql for the query:
SELECT tblClientDetail.ClntDetID, tblClient.GroupName, tblClientDetail.Fund

I have a Main Switchboards which open the following Switchboards
Finance
General Admin
Marketing

My company has decided to start a wellness inititive.  One of the things we
are doing is creating a simple database for wellness tips.  The plan is to
enter tips, link that table to all of our other databases, and create a
pop-up box that displays a tip whenever a user opens a ...

First off I want to say thank you to Microsoft, secondly I want to say that I
have very little experience with access, now onto the problem.  I need to
make a form for my access database and in that form there must be a couple of
fields (Client phone,Client E-mail, Client ...

I hope someone can help me.
I'm building continuous form with about 30 columns displaying some store
information and performance.
Form is too long and I would like to freeze Store column so that Store

I am having trouble with data being erased in my form.  It seems to be a bug,
or something.  It only seems to be in this one subform.  Not all the time,
but it does seem to happen most often with the first change in a record.  It
will erase all of the data just before moving to the ...

Hi, I hope someone can help me.
I have one main form, with four, at least, other forms
within.
The problem is: