When printing in form view, can an empty field be suppressed so it doesn't
print out an empty box.

Hi.  I have 2 tables.  (1) Master table with 1300 + records and primary key
and address fields; (2) Secondary table with a select number of records
linked by the primary key field.  I want to create a form that will bring in
the address fields from Table 1 when I type in the ...

This seems relatively simple but I can't fix it.  I have been creating forms
using the wizard with no problems for several months.  However, all of a
sudden, when I use the wizard to create a form, I cannot view anything
(except the header) in form view.  In design view everything ...

What is the best way to prevent a blank record.  In other words my users will
click the next record at end of form records (on the record selector arrows
on bottom of form).  This will mistakenly create multiple blank records.  How
can this be prevented.  Perhaps I can modify one ...

I have a list box that is populated from a query.  There is a report that
uses the selection from this list to pull data.  The list contains the names
of various employers.  My questions is, is there a way to force the report to
run based on all the employers listed?  In other words ...

Examples from Excell:
=exp(LN(.5)*(22)/15)
=POWER(10,LOG(.5)*(22)/B3)
How do I enter this in a text box on an Microsoft Access form?

I have this code in my subform Me.InsuranceConsultant.Value =
Me.InsuranceConsultant.ItemData(2).
It sets the 3rd selection in my cbo box as the default. This works fine but
if a user wants and selects a different selection from the cbo it changes it

Hi Groupies.
I'm using A2K7
I have an inventory database. Things are working fine except for a few of
our inventory items. These few items are considered "blended" which means

Dear Sir/Mam
I want to create a templete in Access as a quotation. How can I create it
Thanx in advance

I have a form that is used to update a table.  I recently added information
directly into the table (more members) and the form isn't recognizing the new
additions.
I have searched for an answer and have come up empty.  Any assistance is

I have a combo box on my form (frmclientpricingenter) which pulls up a
record and displays the record on form.
I want to enter a value into the combobox, using code, from another form and
then the combobox pulls up the appropriate record.

I have a Combo Box with a limited cust's name from table CUSTOMER. I have no
problem when my users enter a cust name was already on list. Is it possible
MS Access can add automatically a new cust (not on the list) to table
CUSTOMER when the user enter a cust is not on the list?. So ...

I am using Access 2000.
I would like to change the backgrount to tranparent on list boxes on several
forms as well as to centre the text in the boxes.
I use the formatting tools to selct the transparent backgrount and centered

In a subform, in datasheet view, is there a way to make the first line the
new record instead of the bottom line?

i made a popup form to be opened with the OnOpen event of the main form.I
made it in a datahseet view.However when opened it shows only the first row
and is with a very small window.How can i show all the rows in the form ?