the value you entered isn't valid for this field

[Guest]

Hello,

I get the error "the value you entered isn't valid for this field" when
entering some values into a combo-box field.

The combo-box has a query for the row source that returns a list of current
Property_id's and Property names. It is set to NOT limit to list. because I
have VBA code that searches for different variations on property_id's, some
are all numeric and some are alphanumeric.

There is a lot of code, so I don't think I should post it here, but the code
always works regardless of numeric or alphanumeric values. Even using a
value that sometimes generates the error, so I'm sure it is not in the code.
It's something with Access. If the problem happens, I close the form, reopen
the form, and type in the id again and it works.

The system works fine about 95% of the time. but sometimes when typing in
an alphanumeric property id I receive the error.

Something that seems to be part of the problem is that my query (see query
below) uses the more common numeric value as the bound column, this is
because all properties have the property_id, while 75% have the property_id
and another alphanumeric ID. (that's why I had to use all the VBA, The VBA
lets me search for either propertyID).


If you need me to explain more or have other questions, please ask.


thank you,

phil

[ query as row source for combo box set to NOT limit to list ]
SELECT DISTINCTROW active_property.property_id,
active_property.property_name_text, active_property.associated_fha_number
FROM active_property
ORDER BY active_property.property_name_text;

 

[Guest]

Check the table property of the bound column of the combobox. I think you
will find it is number and not text.

 

[Guest]

Hello,

Yes, it is linked to a numeric field in the table, but that is because all
the records have the numeric property_id, but some properties also have
additional id's that include alphanumeric id's. I linked to the numeric for
my bound column because that is the idea that is always available, but I use
the VBA code to allow the form to retreive the alphanumeric property ID's if
they are entered.

Knowing this, is there a way to still use this method and not receive the
error?

My thinking is to use the alphanumeric field as the bound column, but since
only about 50% of the properties have that id I'd have issue's with the
other's.


Thank you,

phil


That does give me a few ideas and helps a little

Check the table property of the bound column of the combobox. I think you
will find it is number and not text.

Hello,

I get the error "the value you entered isn't valid for this field" when
entering some values into a combo-box field.

The combo-box has a query for the row source that returns a list of current
Property_id's and Property names. It is set to NOT limit to list. because I
have VBA code that searches for different variations on property_id's, some
are all numeric and some are alphanumeric.

There is a lot of code, so I don't think I should post it here, but the code
always works regardless of numeric or alphanumeric values. Even using a
value that sometimes generates the error, so I'm sure it is not in the code.
It's something with Access. If the problem happens, I close the form, reopen
the form, and type in the id again and it works.

The system works fine about 95% of the time. but sometimes when typing in
an alphanumeric property id I receive the error.

Something that seems to be part of the problem is that my query (see query
below) uses the more common numeric value as the bound column, this is
because all properties have the property_id, while 75% have the property_id
and another alphanumeric ID. (that's why I had to use all the VBA, The VBA
lets me search for either propertyID).


If you need me to explain more or have other questions, please ask.


thank you,

phil

[ query as row source for combo box set to NOT limit to list ]
SELECT DISTINCTROW active_property.property_id,
active_property.property_name_text, active_property.associated_fha_number
FROM active_property
ORDER BY active_property.property_name_text;

 

[Guest]

Hello everyone,

I found the answer. The way to allow my combo-box to be bound to the
numeric property id value and still use my VBA to find the alternate alpha
property id. It seems after doing some quick 2-minutes of testing , if I
turn off autoCorrect it works.

go to combo-box properties
OTHER tab
allow autocorrect - changed to NO

I hope this helps some other people.


Thank you,