Combo Box Column Widths not allowing 0

[Bill]

Access 2000
Win XP

Hi,
I am creating a basic combo box that binds the first
column (ID) to a field in the current form. Then second
column displays a name.

However when I go to view the form I get this error.

"The value you entered isn't valid for this field."

The column count is 2 and the column widths is 0";2"

However, if I change the column width to 0.0007";2" the
form works fine.
Everywhere I have read I should be able to put the first
column to 0" and still bind to that column. Why isn't it
working?

Bill

 

[Rick Brandt]

Access 2000
Win XP

Hi,
I am creating a basic combo box that binds the first
column (ID) to a field in the current form. Then second
column displays a name.

However when I go to view the form I get this error.

"The value you entered isn't valid for this field."

The column count is 2 and the column widths is 0";2"

However, if I change the column width to 0.0007";2" the
form works fine.
Everywhere I have read I should be able to put the first
column to 0" and still bind to that column. Why isn't it
working?

What value are you entering? If you hide the ID and display the name then
you must enter a name (string), not the ID (number).

 

[Guest]

What value are you entering? If you hide the ID and
display the name then

you must enter a name (string), not the ID (number).

I will repeat what was in my email earlier.

So, when I go to view the form I get the error. I am not
even trying to enter anything in the form.

Bill

 

[Ken Snell]

Changing the width of the first column may be a "noncontributing factor"
here, though it's an unusual result.

The error message that you're getting is from the value of the first field
in the first record of the combo box's row source not being compatible with
the format of the field. Can you post the row source table/query statement,
the data that are in the row source, he format of the combo box (Format
property), etc.?

 

[Rick Brandt]

I will repeat what was in my email earlier.


So, when I go to view the form I get the error. I am not
even trying to enter anything in the form.

Is there code or a macro that is attempting to set a value automatically?
You really should not get that error message just by "looking" at a record.

 

[Bill]

Chaulk this one up for Microsoft. I rebooted my machine
and recreated the combo and everything worked fine.

So why and how it did what it did, the world may never
know.

Bill