List Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003
I created a Db with a field that is a drop down list - with 3 Company names.
On the table and in the Query this field looks good - Black lettering on
white space and the 1 small down arrow. But on my form and in my report this
same field does not appear to be right. The field itself is white lettering
on black space and has 2 small arrows and acts like a vertical bar.

In the Db design for the [company] field, under the lookup tab, I chose:
List Box, Value List and on the row source I put "company A; company B;
company C". Bound column =1, Column Count = 1, Column Heads = No and column
width =.5".
I do not think the problem is here - I think it is in the form, but I do not
know what to look for. Can anyone help me? Please point me in the right
direction.

Aurora
 
Here's a link I think you should read.
The Evils of Lookup Fields in Tables
http://www.mvps.org/access/lookupfields.htm
I am using Access 2003
I created a Db with a field that is a drop down list - with 3 Company names.
On the table and in the Query this field looks good - Black lettering on
white space and the 1 small down arrow. But on my form and in my report this
same field does not appear to be right. The field itself is white lettering
on black space and has 2 small arrows and acts like a vertical bar.

In the Db design for the [company] field, under the lookup tab, I chose:
List Box, Value List and on the row source I put "company A; company B;
company C". Bound column =1, Column Count = 1, Column Heads = No and column
width =.5".
I do not think the problem is here - I think it is in the form, but I do not
know what to look for. Can anyone help me? Please point me in the right
direction.

Aurora
Click to expand...
 
Back
Top