Hi all,

I'm having a problem with a combo box. The combo box shows broker
id's and broker name. The bound field is broker id, the limit to list
property is set to Yes and the Default Value is set to zero. The
broker id is defined in the details table as a number (integer).

If a user enters the wrong broker id a message pops up: The text you
entered isn't an item in the list, but if a blank is entered (hitting
the space key by accident) no message pops up and the record will be
saved with a blank broker id.

Is there another property that needs to be set in combo box or in
the table that will not allow a blank to be entered?

I am using Access 2007

Joe V.

"jovii" <jovi07 (AT) aol (DOT) com> wrote

Try setting the field's "allow zero-length" property to "no".

Keith.
www.keithwilby.co.uk

You have a couple of errors ........
1. The default value can not be 0. There is no BrokerID and BrokerName
with a BrokerID = 0 in the table where you get BrokerID and BrokerName.
2. In the table where you are entering BrokerID with the combobox,
BrokerID should be defined as a number (long integer).

Steve
santus (AT) penn (DOT) com

"jovii" <jovi07 (AT) aol (DOT) com> wrote

jovii wrote:

Do you have a record in the combo's record source that is blank?

Thanks for the replys. The problem was solved when I changed the
Required property on the brokerid field to Yes


On Jul 27, 12:37*pm, Salad <o... (AT) vinegar (DOT) com> wrote:

On Jul 27, 11:56*am, "Steve"
<help_available_at_very_reasonable_ra... (AT) contactme (DOT) com> wrote:

1. The default value can be 0 because a broker might not be involved
in the trade. 0 is a valid selection in the combo box
2. The brokerid field is defined as a number (integer). Any reason
why you prefer long integer instead of integer?

See commnts below .....


"jovii" <jovi07 (AT) aol (DOT) com> wrote

On Jul 27, 11:56 am, "Steve"
<help_available_at_very_reasonable_ra... (AT) contactme (DOT) com> wrote:

1. The default value can be 0 because a broker might not be involved
in the trade. 0 is a valid selection in the combo box

Wrong! BrokerID should be autonumer in your Broker tables. Autonumber is
Long Integer. Therefore, all relationships to BrokerID in the broker table
must be long integer. Access requires that the primary key and the foreign
key in a relationship be the same data type.

2. The brokerid field is defined as a number (integer). Any reason
why you prefer long integer instead of integer?

It's an Access requirement! See #1

Why should brokerid be an autonumber. I work for a small company and
there are only 15 brokers and the office manager prefers to assign
brokerid himself.
Since the broker id in the details table and the broker id (primary
key) in the brokers table are both defined as integer it meets the
Access requirement.



On Jul 27, 9:14*pm, "Steve"
<help_available_at_very_reasonable_ra... (AT) contactme (DOT) com> wrote:

"jovii" <jovi07 (AT) aol (DOT) com> wrote

You can largely disregard most of what Steve says, when he isn't trolling
for victims he's giving dodgy advice.

Thanks for the warning Keith. I thought Steve may know something that
I didn't, but I can see know he's just wasting time.



On Jul 28, 3:56*am, "Keith Wilby" <h... (AT) there (DOT) com> wrote: