I have been confronted with a strange fenomenon in comboboxes.
I'm working with access2000.
I put a simple combobox in a form.
The row source of the combobox is a table and the first field of this table is a number.
The bound column is 1.
When I select a record in the combobox, that number appears, it all seems to work.
However, when I reference the content of the combobox via a query, I receive strange characters.
When I ask for the ASCII value of that character, it is mostly 49 (1) or 50(2).
When I set the column width to zero, the references just work fine.
When I change the format to text, everything works fine.
Can someone explain why this is happening?
I include a simple database to show what is happening.
Look at the queries.
otto
I'm working with access2000.
I put a simple combobox in a form.
The row source of the combobox is a table and the first field of this table is a number.
The bound column is 1.
When I select a record in the combobox, that number appears, it all seems to work.
However, when I reference the content of the combobox via a query, I receive strange characters.
When I ask for the ASCII value of that character, it is mostly 49 (1) or 50(2).
When I set the column width to zero, the references just work fine.
When I change the format to text, everything works fine.
Can someone explain why this is happening?
I include a simple database to show what is happening.
Look at the queries.
otto