Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...
MS Access Forum / Forms Programming / September 2007

Tip: Looking for answers? Try searching our database.

Combo Box Display issues

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sean Henry - 24 Sep 2007 16:32 GMT
All of a sudden a clients comobo boxes dont display the first colum (happens
to be the ID). We dont know of anything fundementally changing over the
weekend.

Other ocmbo boxes work! So the only thing we can get to is a more complex
combo box seems not to display the first column, and simple ones are fine.

Does anyone have any clue about this? I doubt it is actually related to
Access, but I dont know how to start troubleshooting.
Signature

Sean Henry

Reply to this Message
Allen Browne - 24 Sep 2007 16:48 GMT
Sean, is this Access 2003?

If so, your machine may have downloaded Service Pack 3 for Office 2003.
There's a bug in the SP where the combo whose RowSource is a table that has
something in its Format property.

There's a demo of this and another bug in this sample db:
   http://allenbrowne.com/temp/A2003sp3bug.zip

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> All of a sudden a clients comobo boxes dont display the first colum
> (happens
[quoted text clipped - 6 lines]
> Does anyone have any clue about this? I doubt it is actually related to
> Access, but I dont know how to start troubleshooting.
Reply to this Message
CurtainMary - 26 Sep 2007 01:32 GMT
Wow, thanks Allen, I was hoping that a MVP would get onto this. Glad that
professionals like you show some interest in us amateurs.
CurtainMary

> Sean, is this Access 2003?
>
[quoted text clipped - 15 lines]
> > Does anyone have any clue about this? I doubt it is actually related to
> > Access, but I dont know how to start troubleshooting.
Reply to this Message
Sean Henry - 24 Sep 2007 17:24 GMT
Thank you so much. Im checking with the client to see,a nd if so I will post
it back here!
Signature

Sean Henry

> All of a sudden a clients comobo boxes dont display the first colum (happens
> to be the ID). We dont know of anything fundementally changing over the
[quoted text clipped - 5 lines]
> Does anyone have any clue about this? I doubt it is actually related to
> Access, but I dont know how to start troubleshooting.
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.