G
g.evrony
Hey,
I'd appreciate help figuring out this *very* strange Access 2003 bug
that is easily reproducible in 3 minutes. I've searched everywhere
online and haven't seen any mention of this problem.
To reproduce and see what I'm talking about:
1) Start a new blank database
2) Create a table in design view
3) Create one row titled "UserID" of data type "text"
4) Create a second row titled "Car color" of data type "text"
- under the lookup tab, change to "combo box"
- set "row source type" = "value list"
- set "row source" = "black";"orange";"green";
- set bound column = 0
5) close the table and let access create an automatic "autonumber"
primary key.
6) Open the table and put in three random rows of data.
7) Choose "Filter by form"
8) search for * in the userid field.---> Apply filter.
Voila! Bizarre giberish characters appear in the "car color" field.
Also, it becomes impossible to choose any value. If you do and exit,
there is also this weird "can't find macro" error with random chinese
characters.
I appreciate ANY ideas and help.
I'd appreciate help figuring out this *very* strange Access 2003 bug
that is easily reproducible in 3 minutes. I've searched everywhere
online and haven't seen any mention of this problem.
To reproduce and see what I'm talking about:
1) Start a new blank database
2) Create a table in design view
3) Create one row titled "UserID" of data type "text"
4) Create a second row titled "Car color" of data type "text"
- under the lookup tab, change to "combo box"
- set "row source type" = "value list"
- set "row source" = "black";"orange";"green";
- set bound column = 0
5) close the table and let access create an automatic "autonumber"
primary key.
6) Open the table and put in three random rows of data.
7) Choose "Filter by form"
8) search for * in the userid field.---> Apply filter.
Voila! Bizarre giberish characters appear in the "car color" field.
Also, it becomes impossible to choose any value. If you do and exit,
there is also this weird "can't find macro" error with random chinese
characters.
I appreciate ANY ideas and help.