Combo Box Blank?

[Lost Target]

Office Pro 2003.

Downloaded service pack update (#3) on 10 Oct.

When I open the combo box in an exisitng database I see the index numbers,
but not Lname or Fname.

The spaces for the information is there, but blank (white).

I deleted and put in a new combo box but same view.

I tried making a test database, but same result.

I just use the combo box to quickly bring up a persons file.

The data base has been in use for more then a few years.

Something changed when I downloaded SP 3.

Any ideas on what I need to change to display all fields.

 

[Pieter Wijnen]

bug in SP3
Remove > Formatting from the Fields (in the table) or concanate with an
empty string
ie
LName & ""

HtH

Pieter

 

[CiceroINFJ]

I have exactly the same problem with SP3. After the install, some columns in
my combo boxes in Access are blank while other columns in the same combo box
are populated with data.

Pieter - what exactly do you mean by saying "Remove > Formatting from the
Fields (in the table) or concatenate with an empty string". What formatting
should I remove?

Concatenation is not really an option as I have a whole bunch of combo boxes
in my database and it will take days to fix the SP3 bug this way manually in
my Access app.

Thanks for your help,

V

 

[HELENA SMITH]

(e-mail address removed) hi are you

I have exactly the same problem with SP3. After the install, some columns in
my combo boxes in Access are blank while other columns in the same combo box
are populated with data.

Pieter - what exactly do you mean by saying "Remove > Formatting from the
Fields (in the table) or concatenate with an empty string". What formatting
should I remove?

Concatenation is not really an option as I have a whole bunch of combo boxes
in my database and it will take days to fix the SP3 bug this way manually in
my Access app.

Thanks for your help,

V