Second Column In Combo Box is invisible.

[Bob Quintal]

@i12g2000prf.googlegroups.co
m:

Hi All,

I have a very strange thing happening to my database, not quite
sure what the root of the problem, but it seems to be only
happening to combo boxes that are looking up information from
table tbl_Clients.

My Main table "tbl_Projects" and forms (projects have 3 look up
fields) and have look up query "SELECT tbl_Clients.CompanyID,
tbl_Clients.Company FROM tbl_Clients;"

On the combo list properties i have bound column as 1 but set to
show 2 columns and column sizes set to 0cm;6cm

and what was happening was that column 1 was hidden and column 2
was showing the company names to select.

this morning i open the database and the look up combos (Lists are
invisible) But I'm able to select company's, but cant see who I'm
selecting. so i opened the Properties Box and clicked on the data
row source so it open the Select Query Window. and it shows the
both columns perfectly,

So I changed the Column Sizes to 2cm;6cm and its show the
CompanyID Column Perfectly fine, but the Company Column is still
showing the details invisible.

things ive tried, But no luck,

1 Inserting a new combo box
2 Changing the font color and type.
3 Limit to list Yes/No

Ive also been into the tbl_Projects its self and its happening
here as well.

any ideas or solutions to fix this issue?


Thanks for your time advance.

Dan

This is due to a bug introduced in MS-Office Service Pack 3. The
cause is a format in the tbl_Clients.Company field definition.
Either remove that or modify the query to show
"SELECT tbl_Clients.CompanyID,
tbl_Clients.Company & "" as Company FROM tbl_Clients;"

MS are looking for a solution.

 

[dan.cawthorne]

Hi All,

I have a very strange thing happening to my database, not quite sure
what the root of the problem, but it seems to be only happening to
combo boxes that are looking up information from table tbl_Clients.

My Main table "tbl_Projects" and forms (projects have 3 look up
fields) and have look up query "SELECT tbl_Clients.CompanyID,
tbl_Clients.Company FROM tbl_Clients;"

On the combo list properties i have bound column as 1 but set to show
2 columns and column sizes set to 0cm;6cm

and what was happening was that column 1 was hidden and column 2 was
showing the company names to select.

this morning i open the database and the look up combos (Lists are
invisible) But I'm able to select company's, but cant see who I'm
selecting. so i opened the Properties Box and clicked on the data row
source so it open the Select Query Window. and it shows the both
columns perfectly,

So I changed the Column Sizes to 2cm;6cm and its show the CompanyID
Column Perfectly fine, but the Company Column is still showing the
details invisible.

things ive tried, But no luck,

1 Inserting a new combo box
2 Changing the font color and type.
3 Limit to list Yes/No

Ive also been into the tbl_Projects its self and its happening here as
well.

any ideas or solutions to fix this issue?


Thanks for your time advance.

Dan

 

[Douglas J. Steele]

I'm guessing (since you didn't say) that you're using Access 2003 and you
just installed Office 2003 SP3 to your machine.

There's a serious bug in that service pack. If a table that makes up the
record source of a combo box (or list box) has the Format property set on
any field, you'll experience the symptom you're seeing. The solution is to
go back and remove the format from the field.

 

[dan.cawthorne]

I'm guessing (since you didn't say) that you're using Access 2003 and you
just installed Office 2003 SP3 to your machine.

There's a serious bug in that service pack. If a table that makes up the
record source of a combo box (or list box) has the Format property set on
any field, you'll experience the symptom you're seeing. The solution is to
go back and remove the format from the field.

SP3 is the Cause, Ive Just Downloaded The Database Back End and Front
End, From The Citrix Platform Down to my desktop and reopend the
database in my version of access 2003 Minus the SP3 and Works
Perfectly Fine.

So Whats the Work around? as the database needs to be on citrix, but
our citrix is out sourced to a external company,.

Regards

Dan

 

[dan.cawthorne]

SP3 is the Cause, Ive Just Downloaded The Database Back End and Front
End, From The Citrix Platform Down to my desktop and reopend the
database in my version of access 2003 Minus the SP3 and Works
Perfectly Fine.

So Whats the Work around? as the database needs to be on citrix, but
our citrix is out sourced to a external company,.

Regards

Dan

Just Thought Id Let you Know I managed to find a Field in my database
that had > in a field. works fine now.

 

[duanemoore]

SP3is the Cause, Ive Just Downloaded The Database Back End and Front
End, From The Citrix Platform Down to my desktop and reopend the
database in my version of access 2003 Minus theSP3and Works
Perfectly Fine.

So Whats the Work around? as the database needs to be on citrix, but
our citrix is out sourced to a external company,.

Regards

Dan

Please also see http://www.allenbrowne.com/tips.html "New bugs in SP3
for Access 2003" to see even worse problems in Access 2003 caused by
SP3. It's worse than just what you've experienced.