-
Access 2003 & blank drop down list after installing SP3
Posted on September 21st, 2007 8 commentsI was at a customers site today when i had an Access database presented to me
“Where has all the data gone?!”Â
When attempting to select a value in a drop down (combo) the list appeared empty. If you selected an item the field value was updated correctly.
I found this a little wierd and it appeared to be affecting everyone and it appeared to only be occuring with instances with a particular field.
I went to the underlying table and it turns out this particular field had some custom formatting applied. All the other fields did not
I removed the formatting and everything returned to normal
It was sorted but i was still scratching my head as to WHY when someone said
“It was fine until yesterday, then it all went funny this morning”
So what changed? Turns out “someone” had installed Office 2003 SP3
A bit of searching after the event turns out i’m not the only one who has run into this!
8 Responses to “Access 2003 & blank drop down list after installing SP3”
-
I had to review the ACCESS tables to get the formatting correct after Office SP3 was pushed. The formats were set to “>”. Removing that resolved the issue.
jp
-
Yeah, there were “>”s in all of my text-based field format fields too! Maybe SP3 put them in there! Thanks Andy!
-
Evan Young April 16th, 2008 at 9:08 pm
I had this fixed – was the error re-introduced on the most recent patch Tuesday?
Evan
-
Hi Evan
I haven’t seen any problems at the moment
Will keep an eye out
Andy
-
Derek King May 15th, 2008 at 8:58 am
I have a multi user Access database and only one machine was showing blank dropdown boxes. It was the only machine running Office 2003 SP3. I have removed the “>” and all is OK. Many thanks
Derek -
I had the problem BEFORE installing SP3, but thanx for the solution
-
I had the same problem after the SP3 update and your solution worked. Perhaps Microsoft should take a look at this. Nancy
-
I use this patch to solve mi problem.
http:// support.microsoft.com/kb/943967
“Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007″http:// support.microsoft.com/kb/945674/
“After you install Office 2003 SP3, you encounter various problems in an Access project when you work with a Bit data type column in a linked SQL Server table”
Leave a Reply
-



![[This is a SBS Community blog you are reading. Are you subscribed to the Official SBS blog?]](http://www.sbslinks.com/images/sbsblogweb.jpg)


Recent Comments