If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2003 Look up field not displaying properly
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????? |
#2
|
|||
|
|||
Access 2003 Look up field not displaying properly
First guess - look at the Column Count and Column Width proprties.
Steve "Diana1130" wrote in message ... 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????? |
#3
|
|||
|
|||
Access 2003 Look up field not displaying properly
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 "Diana1130" wrote in message ... 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????? |
#4
|
|||
|
|||
Access 2003 Look up field not displaying properly
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 "Diana1130" wrote in message ... 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????? . |
Thread Tools | |
Display Modes | |
|
|