Prev: Dates Validation for Overlapping & Gaps (Leo asked)
Next: "expression in argument 3 invalad value"
From: Diana1130 on 20 Dec 2009 11:25
I have a look up field in a form that is not displaying correctly. When I
open the form and click on the Business area field, my combo box opens
however there is no visible list to choose from; however if I pretend i see
something scroll down and click, then one of the choices does appear in my
field.

What am I not doing?????
From: Steve on 20 Dec 2009 12:02
First guess - look at the Column Count and Column Width proprties.

Steve
santus(a)penn.com


"Diana1130" <Diana1130(a)discussions.microsoft.com> wrote in message
news:85ADD229-A50A-4A27-A3C3-39C8FCEB6360(a)microsoft.com...
>I have a look up field in a form that is not displaying correctly. When I
> open the form and click on the Business area field, my combo box opens
> however there is no visible list to choose from; however if I pretend i
> see
> something scroll down and click, then one of the choices does appear in my
> field.
>
> What am I not doing?????


From: Steve on 20 Dec 2009 12:18
If my first response doesn't help, is the rowsource of your combobox your
business area table, a query based on your business area table or a value
list containing a list of your business areas? If a table or query, post the
fields in order. If a value list, post the list. Then go to the form
containing the combobox and open it in design view. Select the combobox,
open properties and post the bound column property under the Data tab. Go to
the Format tab and post the Column Count and Column Width properties.

Steve
santus(a)penn.com


"Diana1130" <Diana1130(a)discussions.microsoft.com> wrote in message
news:85ADD229-A50A-4A27-A3C3-39C8FCEB6360(a)microsoft.com...
>I have a look up field in a form that is not displaying correctly. When I
> open the form and click on the Business area field, my combo box opens
> however there is no visible list to choose from; however if I pretend i
> see
> something scroll down and click, then one of the choices does appear in my
> field.
>
> What am I not doing?????


From: Diana1130 on 21 Dec 2009 21:21
Steve~

Thank you for the suggestion. Just overlooked the count on the form itself.
Appreciate the help.

Diana

"Steve" wrote:

> If my first response doesn't help, is the rowsource of your combobox your
> business area table, a query based on your business area table or a value
> list containing a list of your business areas? If a table or query, post the
> fields in order. If a value list, post the list. Then go to the form
> containing the combobox and open it in design view. Select the combobox,
> open properties and post the bound column property under the Data tab. Go to
> the Format tab and post the Column Count and Column Width properties.
>
> Steve
> santus(a)penn.com
>
>
> "Diana1130" <Diana1130(a)discussions.microsoft.com> wrote in message
> news:85ADD229-A50A-4A27-A3C3-39C8FCEB6360(a)microsoft.com...
> >I have a look up field in a form that is not displaying correctly. When I
> > open the form and click on the Business area field, my combo box opens
> > however there is no visible list to choose from; however if I pretend i
> > see
> > something scroll down and click, then one of the choices does appear in my
> > field.
> >
> > What am I not doing?????
>
>
> .
>
 | 
Pages: 1
Prev: Dates Validation for Overlapping & Gaps (Leo asked)
Next: "expression in argument 3 invalad value"