column data disappears

[Eupher]

Okay, just got a brand new computer on my desk at work, a 2.4 gHz Intel processor, an nVidia GeForce 5200 video card, a Philips flat panel LCD, etc. So now I'm getting some strange form behavior in my databases. If I open a form that contains a listbox, then open a table from the database window such that the form is covered up, then close the table by clicking the "X", data disappears from the listbox display. What's really odd is it's *only* in columns that use an expression. Columns that pull the data directly from the recordsource are unaffected. Likewise, if I drag the borders of the table window such that the listbox is in view, the data is still there, and does not disappear when closing the table window.

An example: a listbox that contains 2 columns. Column 0 uses an expression to concatenate data from 2 fields, like so:

Name: [Last name] & ", " & Left([First name], 1) & "."

Column 1 simply pulls the SSN straight from the table field, no calculation or expression.

The table window trick causes the Name field data to disappear, but the SSN data is still there. As far as I can tell, this only occurs with a table or query window. Reports, forms, and code windows don't do it. The underlying data is not affected, pressing F9 restores the view.

Weird, huh?

Suspecting a video driver issue, I downloaded and installed the latest driver from nVidia, but it made no difference. I've heard there are some video issues with nVidia cards and Windows XP. Anybody got any insight? Thanks!

Ken S.

 

[mgolla]

Actually,

Have you ran office update?

I saw the same problem when I designed on a computer with office on SP-3 but the computer using the program was on original no service pack. I installed the SP-1 and the problem was fixed.

HTH
Mike

 

[Eupher]

Mike, thanks for the tip. All critical updates are installed as well as all updates for Office XP. Curently running Access version 10.4302.4219-SP2. Problem still exists.