Hello World:

I have two tables, one called Assets and the other table called Job Sites.

the Assets table has several fields
AssetID - autonumber
plus others

the Job Sites table has two fields
JobSiteID - autonumber
JobSite - text (with about 22 names in it)

the I add the JobSite to the Assets table (hiding the JobSiteID) it shows me the expected drop down box but it is BLANK. If I click on any of the BLANK spaces in the drop down, it populates the field.

It is behaving as if the font color was white.

Any ideas??? I am baffled. :confused: :confused:

If you are describing a ComboBox then please post:
1-RowSourceType
2-RowSource
3-BoundColumn
4-ColumnCount
5-ColumnWidths
6-ListWidth

as requested...

1-RowSourceType - table/Query
2-RowSource - SELECT tblJobSites.JobID, tblJobSites.JobSite FROM tblJobSites ORDER BY [JobSite];
3-BoundColumn - 1
4-ColumnCount - 2
5-ColumnWidths - .5";1.5"
6-ListWidth - 2"

Change

5-ColumnWidths - .5";1.5"

to

5-ColumnWidths - 0";1.5"

Any chance you are using ac2003 with SP3 applied?

-From Allen Browne's site: New bugs in SP3 for Access 2003

1. The combo goes blank if it's RowSource is a table field that has something in its Format property.

yes I do have sp3 installed. Any workaround you know of?

thanks 4 ur help RG.

Remove whatever you have in the Format property of the field? Uninstall SP3?

yeap. removing the formatting works just fine.
thanks again.:D

Cool...now we both know what the solution is for that symptom. Thanks for posting back.