A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2003 Look up field not displaying properly



 
 
Thread Tools Display Modes
  #1  
Old December 20th, 2009, 05:25 PM posted to microsoft.public.access.tablesdbdesign
Diana1130
external usenet poster
 
Posts: 2
Default 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?????
  #3  
Old December 20th, 2009, 06:18 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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  
Old December 22nd, 2009, 03:21 AM posted to microsoft.public.access.tablesdbdesign
Diana1130
external usenet poster
 
Posts: 2
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:21 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.