Re: Second Column In Combo Box is invisible.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 MVP
http://I.Am/DougSteele
(no private e-mails, please)


<dan.cawthorne@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


.

Relevant Pages

  • Second Column In Combo Box is invisible.
    ... I have a very strange thing happening to my database, ... this morning i open the database and the look up combos (Lists are ... So I changed the Column Sizes to 2cm;6cm and its show the CompanyID ... but the Company Column is still showing the ...
    (microsoft.public.access.formscoding)
  • Re: Are any stations showing remastered Star Trek (TOS) in HDTV?
    ... The titantv schedule link at KNBC's website lists a showing of the Balance of Terror at 12:05 AM Sunday night. ... Thanks for the links of stations showing TOS. ...
    (alt.tv.tech.hdtv)
  • Re: "reservations required"?
    ... Reservations and waiting lists won't help unless there is a meaingful ... penalty for making a reservation and not showing up. ... If you have seating for 19 tables and only 36 pairs show up, ...
    (rec.games.bridge)
  • RE: Settings of Data Validation
    ... I have lists with way more than 8 entries and the drop-down box always works ... when use a list to show the data source for a cell in an Excel file, ... maximum items that showing from the list when user clicks on it is 8 items, ...
    (microsoft.public.excel.misc)
  • Data Comparison
    ... I run off a monthly report of products completed by employees. ... Etc but it lists about 300 staff over 14 pages when I copy it and paste it ... I want to be able to drop it in Excel like above with the names split form ... spreadsheet showing were they work. ...
    (microsoft.public.excel)