problem with combo box

  • Thread starter Thread starter Boodi
  • Start date Start date
B

Boodi

am building a form using data access page but the problem
is "when i want to show more than one column in the combo
box it just shows the first one?????????? while in the
form it shows even three.?????????/


** i also don't have microsoft date and time picker in my
access active x control.


** am using version 2002.
plz help in this.
 
You seem very impatient... next time please try to post
each question once, and give ppl a chance to reply.

try setting the ComboBox' properties so that you have:
Column Count = 3 (or the number of columns you want)
Column Heads = Yes
Column Widths = (the widths of the columns you want,
seperated with semicolon; - like so: 0cm;2cm;1.5cm (first
column hidden))
ListWidth = sum of the column widths you want (3.5cm)
those are all in the Format section of the property sheet.
Also make sure you set the right RowSourceType and
RowSource in the Data section.
Good Luck
Ayelet
 
Hi,

The following Microsoft article applies to Access 2000 but
I'm not sure if it applies to 2002:

http://support.microsoft.com/?id=202454
(ACC2000: Page Dropdown and List Box Can Only Display One
Column)

The following is taken from the Access 2002 help file
topic (About types of controls in Access) and the last
sentance is relevant to your question.

'Drop-down list boxes On a data access page, you can use
a drop-down list box instead of a list box. A drop-down
list box on a data access page looks like a combo box on a
form. As in a combo box, a drop-down list box shows only
one record until you click to expand the contents;
however, you can't type new values in a drop-down list
box. The list in a drop-down list box consists of rows of
data. Rows can have only one column that appears without
headings.'

hth

chas
 
Back
Top