Combo Box problems in DataSheet view in SubForm

[Will]

- Combo Box works in DataSheet view but Arrow that indicates it is a Combo
box is not visible until you click in the field... is there anyway to fix
this?

- Multiple columns don's show up in the combo Box when it is in DataSheet
view... any way to fix this?

I am using the DataSheet view because the form is used as a SubForm and we
want to show multiple items... like Order_Items would appear in an Order
Form.

Is there another way to have the SubForm show multiple records other than by
making it a DataSheet view?

thanks for any help.

 

[Al Camp]

Will,
There are 3 types of forms. Single, datasheet, and continuous.
A continuous form displays multiple records just as a datasheet form, but
with much more flexibility and control.
In design mode for your datasheet subform, change the DefaultView to
Continuous. In design view, you can make a continous form look just like a
datasheet view.

In a continuous form, the combo boxes always display their arrows.

If your combo box doesn't show all the columns, use the Width property to
force the combo to show all the fields.
Set the ListWidth property to the sum of all your column widths, rather
than the default Auto setting.
Given 3 columns...
ColumnWidths = .5";1.0";1.0"
Then set ListWidth = 2.5"
-
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions