Re: List Box Display Anomaly

Michael, since it works fine on one machine but not on the other, you are looking to pin down the difference.

Is there any chance that one machine has had Office 2003 Service Pack 3 applied? There were some bugs introduced by SP3 for Office 2003, including combo display problems:
http://allenbrowne.com/bug-Access2003SP3.html

If that's the issue, the hotfix (last link in the short web page above) might solve it.

--
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.

"Michael" <mcallas@xxxxxxxxxxxxx> wrote in message
news:Tbnxj.8353$yk5.5504@xxxxxxxxxxxxxxx
I use a list box to display query results for record searches. The underlying query uses two tables. It has worked fine for years. All of a sudden, the columns from one of the tables is not displaying in the list box, but if I run the query in the query window, all the columns return data. I have not made any changes to the table or form or list box used in this process. It literally just started happening today.

The list box displays fine on one of my boxes but not the other (both XP Pro; Access 2003). I delivered a new front-end to a client this morning and he alerted me the anomaly. I restored his previous front-end and the list box displayed fine. However, I downloaded the exact same front-end that is working fine on his box (XP Pro, Access 2000) and that is the one that works on one of my boxes but not the other.

Am I just going crazy or has anyone ever experienced this before? I have not been able to find any online documentation referring to this error. Any help is appreciated.
Thanks.
Michael Callas

.

Relevant Pages

  • Re: List Box Display Anomaly
    ... You undoubtedly saved me several hours trying to pin this one down. ... There were some bugs introduced by SP3 for Office 2003, including combo display problems: ... The underlying query uses two tables. ... I delivered a new front-end to a client this morning and he alerted me the anomaly. ...
    (microsoft.public.access.forms)
  • List Box Display Anomaly
    ... I use a list box to display query results for record searches. ... I delivered a new front-end to a client this morning and he alerted me the anomaly. ... However, I downloaded the exact same front-end that is working fine on his box (XP Pro, Access 2000) and that is the one that works on one of my boxes but not the other. ...
    (microsoft.public.access.forms)
  • Re: Tageslichttaugliches TFT mit =?ISO-8859-1?Q?700cd/m=B2?=
    ... > Michael Schick wrote: ... >>>Wer hat Erfahrung mit tageslichttauglichen TFTs? ... >> Also ich kann meinen TFT auch bei Tageslicht benutzen, ... Betrachte dann dein Display, drehe es im Uhrzeigersinn ...
    (de.comp.hardware.monitore)
  • Re: OLAP Cube in Excel
    ... "Michael Vardinghus" wrote: ... > Sub CheckSetting() ... that I want to display all months of the year regardless of ... >> There is an option field within the PivotTable Properties Form in Excel, ...
    (microsoft.public.sqlserver.olap)
  • RE: calculated member question -- why (null)?
    ... why would a calculated member with a constant value ... "Michael D." ... ROWS FROM [Adventure Works] ... (My actual query is still slightly ...
    (microsoft.public.sqlserver.olap)