Vista and 2002-2003 database
in [General]
|
Prev: SELECT @@IDENTITY in A2010 with Triggers
Next: Word 2003 using data from a drop down list (legacy form field)
From: Guy Lydig on 10 Apr 2010 23:53 I had a 2002-2003 database that worked fine in Windows XP. Now that my computer has Vista, I am having a problem with a form. The form opens and my drop-down list of names is blank. The names on the list are there because if I click on a line, a name will sometimes show but other times will not. If I enable other columns to show, for instance with numbers or dates, that information does show on each line. However, the column with names is BLANK. Help.... Any ideas?
From: Jeanette Cunningham on 11 Apr 2010 00:31 See if this helps. "Combo box controls and list box controls display no value or incorrect values in Access 2003 after you install Office 2003 Service Pack 3." And a few more problems SP3 introduced. Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007 - 945674 http://support.microsoft.com/kb/945674 > If the field to which the combo box is bound has a Format property setting > for the field in the table, then yes, this is a bug that has been reported > by many ACCESS users during past weeks. It apparently is a bug in Office > 2003 SP3, which was released by MS a short time ago. MS is aware of the > bug and is working on how to fix it. > > In the meantime, the "complete workaround" is to remove the Format > property's value from the field's properties in the table's design view Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Guy Lydig" <GuyLydig(a)discussions.microsoft.com> wrote in message news:E0820C05-EDBA-4120-8A63-7F313B7C095F(a)microsoft.com... >I had a 2002-2003 database that worked fine in Windows XP. Now that my > computer has Vista, I am having a problem with a form. The form opens and > my > drop-down list of names is blank. The names on the list are there because > if > I click on a line, a name will sometimes show but other times will not. If > I > enable other columns to show, for instance with numbers or dates, that > information does show on each line. However, the column with names is > BLANK. > > Help.... > > Any ideas?
From: Guy Lydig on 11 Apr 2010 01:07
Based on posts I read on this board, I deleted the @ from the name field format on the underlying table and now all is well. So apparently it wasn't Vista that was the issue but Access 2003... I'm going to tell my husband not to update my computer software. Ain't broke... don't fix it! "Guy Lydig" wrote: > I had a 2002-2003 database that worked fine in Windows XP. Now that my > computer has Vista, I am having a problem with a form. The form opens and my > drop-down list of names is blank. The names on the list are there because if > I click on a line, a name will sometimes show but other times will not. If I > enable other columns to show, for instance with numbers or dates, that > information does show on each line. However, the column with names is BLANK. > > Help.... > > Any ideas? |