P
Paul
Hi,
I have a form with a number of combo boxes. The record source of the combos
is changed dynamically and can return text, date or numbers.
Most of the time this works fine, but occasionally (I cannot work out the
precise steps to reproduce) one of the combos will start to report "The
value you entered isn't valid for this field".
It seems that if the combo is returns a numeric data set, then the source is
changed to return a text data set, the combo will sometimes continue to
expect a numeric entry and 'reject' text entries (the combo also right
aligns the entries suggesting a numeric is expected).
I have tried changing the format to "", and requerying the combo when I
change the recordsource, but nothing seems to set it back to expecting text.
At what point does a combo 'figure out' what kind of data to expect and can
this be reset?
As the behaviour is not entirely consistent - is this a bug? Does anyone
know a workaround?
Thanks
Paul
I have a form with a number of combo boxes. The record source of the combos
is changed dynamically and can return text, date or numbers.
Most of the time this works fine, but occasionally (I cannot work out the
precise steps to reproduce) one of the combos will start to report "The
value you entered isn't valid for this field".
It seems that if the combo is returns a numeric data set, then the source is
changed to return a text data set, the combo will sometimes continue to
expect a numeric entry and 'reject' text entries (the combo also right
aligns the entries suggesting a numeric is expected).
I have tried changing the format to "", and requerying the combo when I
change the recordsource, but nothing seems to set it back to expecting text.
At what point does a combo 'figure out' what kind of data to expect and can
this be reset?
As the behaviour is not entirely consistent - is this a bug? Does anyone
know a workaround?
Thanks
Paul