Re: Second Column In Combo Box is invisible.
- From: duanemoore@xxxxxxxxx
- Date: Wed, 19 Dec 2007 13:59:01 -0800 (PST)
On Dec 18, 7:07 am, "dan.cawtho...@xxxxxxxxx"
<dan.cawtho...@xxxxxxxxx> wrote:
On 18 Dec, 11:36, "Douglas J. Steele"
<NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote:
I'm guessing (since you didn't say) that you're using Access 2003 and you
just installedOffice 2003SP3to 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.
--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)
<dan.cawtho...@xxxxxxxxx> wrote in message
news:bb69f5b5-7971-4bf7-8332-41b71e9e7853@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
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.
.
- References:
- Second Column In Combo Box is invisible.
- From: dan.cawthorne@xxxxxxxxx
- Re: Second Column In Combo Box is invisible.
- From: Douglas J. Steele
- Re: Second Column In Combo Box is invisible.
- From: dan.cawthorne@xxxxxxxxx
- Second Column In Combo Box is invisible.
- Prev by Date: Re: Multiple Record(12 Entries) Into Table w/ Form
- Next by Date: Re: Using LIKE
- Previous by thread: Re: Second Column In Combo Box is invisible.
- Next by thread: Re: HELP !! Combo box to feed other combo boxes
- Index(es):
Relevant Pages
|
