Re: Second Column In Combo Box is invisible.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

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

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
.

Relevant Pages

  • Re: Second Column In Combo Box is invisible.
    ... record source of a combo box has the Format property set on ... SP3 is the Cause, Ive Just Downloaded The Database Back End and Front ... From The Citrix Platform Down to my desktop and reopend the ...
    (microsoft.public.access.formscoding)
  • Re: Access crashes when opening form
    ... You were correct in suspecting SP3. ... I've also had a problem with "compact on close" not working (it creates ... database works correctly there. ... Tell us about the field you suspect. ...
    (microsoft.public.access.forms)
  • Re: Access crashes after SP3 installed
    ... uninstalling removed all my desktop shortcuts. ... I'm now getting this error after applying SP3 yesterday. ... Every table in my database has more than 10 fields. ... I am personally do not using any type of formatting for a table. ...
    (microsoft.public.access.formscoding)
  • DMO.Database transfer method issue
    ... SQLServer 2000 (SP3) with security patch applied. ... owner of "master database" is the same as the newly created one. ... Dim oSQLSVR2 As New SQLServer2 ...
    (microsoft.public.sqlserver.programming)
  • DMO.Database.transfer method issue/problem!
    ... SQLServer 2000 (SP3) with security patch applied. ... owner of "master database" is the same as the newly created one. ... Dim oSQLSVR2 As New SQLServer2 ...
    (microsoft.public.sqlserver.programming)