Another Dropdown control problem

  • Thread starter Thread starter Dwayne Conyers
  • Start date Start date
D

Dwayne Conyers

When we enter the form and select a dropdown, we get the error:

"Reporting Database
The value you entered isn't valid for this field
For example, you may have entered text in a numeric field or a number that
is larger than the FieldSize setting permits."

There are only four items in the source table.

After clicking OK on the error message, the dropdown functions normally,
except that the second item in the table that populates the dropdown changes
from the original (text) value to the numeric value of the selected item.

No other rows are overwritten... only that one.

If we re-open and select another value from the dropdown, the second row is
overwritten again with the selected row.

If we go to the table and change the value back it is fine... but it will
not accept manual entry of text in the form.
 
Hi Dwayne,

Do you have reproduce steps? It seems like the scenario below?

"When you have an unbound combo box that can be populated with numeric or
text data, if you set the row source of the combo box with numeric data
first, then go back and try to populate it with text data you receive the
error "The value you entered isn't valid for this field" If you populate
the combo box with text data first, then you can go and select numeric data
and you do not receive this error"

If the issue is the same, the workaround is:

1.Open the form in design view and open the properties box
2.Switch to form view, you should still see the properties box
3.Click on combo4 to see its properties
4.Put the cursor in the row source of combo4
5.Hit shift F2 to zoom in
6.Click OK
7.Tab out of the row source box
8.Close the form and say yes to save the changes
9.Re-open the form and select numericdata first and a number
10.Go back and select textdata and some text
11.Notice you do not get this error now.

Otherwise, would you please post the reproduce steps so I can do some test
for you?

If you have any concerns or questions, please feel free reply to the
threads.



Sincerely,

Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <www.microsoft.com/security>

This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| Reply-To: "Dwayne Conyers" <[email protected]>
| From: "Dwayne Conyers" <[email protected]>

| When we enter the form and select a dropdown, we get the error:
|
| "Reporting Database
| The value you entered isn't valid for this field
| For example, you may have entered text in a numeric field or a number that
| is larger than the FieldSize setting permits."
|
| There are only four items in the source table.
|
| After clicking OK on the error message, the dropdown functions normally,
| except that the second item in the table that populates the dropdown
changes
| from the original (text) value to the numeric value of the selected item.
|
| No other rows are overwritten... only that one.
|
| If we re-open and select another value from the dropdown, the second row
is
| overwritten again with the selected row.
|
| If we go to the table and change the value back it is fine... but it will
| not accept manual entry of text in the form.
|
|
|
 
Back
Top