PC Review


Reply
Thread Tools Rate Thread

Access 2003 Look up field not displaying properly

 
 
Diana1130
Guest
Posts: n/a
 
      20th Dec 2009
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?????
 
Reply With Quote
 
 
 
 
Steve
Guest
Posts: n/a
 
      20th Dec 2009
First guess - look at the Column Count and Column Width proprties.

Steve
(E-Mail Removed)


"Diana1130" <(E-Mail Removed)> wrote in message
news:85ADD229-A50A-4A27-A3C3-(E-Mail Removed)...
>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?????



 
Reply With Quote
 
Steve
Guest
Posts: n/a
 
      20th Dec 2009
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
(E-Mail Removed)


"Diana1130" <(E-Mail Removed)> wrote in message
news:85ADD229-A50A-4A27-A3C3-(E-Mail Removed)...
>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?????



 
Reply With Quote
 
Diana1130
Guest
Posts: n/a
 
      22nd Dec 2009
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
> (E-Mail Removed)
>
>
> "Diana1130" <(E-Mail Removed)> wrote in message
> news:85ADD229-A50A-4A27-A3C3-(E-Mail Removed)...
> >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?????

>
>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
2003 Chart not displaying properly in 2007 Kwadjo Microsoft Excel Charting 1 2nd Jul 2009 05:42 AM
Calender not displaying properly in 2003 =?Utf-8?B?Sm9l?= Microsoft Outlook Discussion 0 15th Nov 2006 10:11 PM
Cutom date field not displaying properly PJ444 Microsoft Outlook Discussion 0 26th Apr 2006 04:24 PM
GUID field does not retrieve data properly - Access 2003 BUG? =?Utf-8?B?SmVmZg==?= Microsoft Access Forms 2 3rd May 2005 05:53 PM
Properly displaying record by field in a Report =?Utf-8?B?Um9u?= Microsoft Access Reports 1 21st Dec 2004 03:21 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:39 PM.