drop down wont display

[gromit95]

hi


i have a database that i worked on on my personal laptop (XP sccess 2003)
now i moved it to my work pc (xp access 2003) and 2 of the 4 dropdowns no longer display contents from table. i get the drop down box and slider
and if i click in the box it will fill in the field i just cant see what it is i'm selecting. is there somthing on my desktop set incorectly or did i loose somthing in the move from my laptop?

thanks fred
new to access
new to this forum

[chris11590]

I am new to access also, but so many people have me so i want to try to help someone. I had a similiar problem and the control source didnt have a value to read. hope this helps...

[Ahmed Elalfy]

Dear Gromit95

I think you change something in the design of the database like fields names in tables or form ...
To correct this error you can open the form in design view
Right click on the corrupted combo box
Click properties
Click data tab
In row source click on the (...) button on the right
This will open query builder
Insert the table which contains the data you need to appear in combo box(Vendor list as per your photo)
Bouble click on the required field to add it to the query
Close
Save

Open the form in form view
Test the combo box

Please try and feedback

Thanks

Ahmed

[pat3]

I had this same problem and have identified the issue. It only began happening after I updated to SP3. This issue is: if your dropdown field has as its row source a table, and the field you wish to display is formatted in the table design (say for all caps using >), then the field will be invisible in the dropdown. I say invisible because if you select it it will display as the selected value, but not show up in the dropdown. The workaround is to remove the formatting from the field in the table design, and format the field in the query of the row source of the field (for all caps use UCase(fieldname)).

I came here looking for a fix to the issue myself, hoping Microsoft might have seen it and fixed it as a bug in SP3.