Quik and esy question on Report output

R

RC

I have a Product column in a table that is a combo box and when I pull a
report on the table the combo box shows up but the selected product is
blacked out. How can I solve this issue?

Thanks RC
 
J

Jeff C

open your report in design mode and check the properties of the field that is
printing black...check the fore and background colors...maybe they are messed
up
 
R

RC

I have looked at the properties of the field of the combo box on the report
and the color is correct. The Row Source Type is Table/Query and the Row
Source is SELECT Stations.Product FROM Products, Stations
 
L

Larry Daugherty

Hi,

It sounds like you may have fallen into Microsoft's Lookup Field trap. If
that's the case, get rid of them. They violate Relational rules in that the
field that uses them is no longer atomic, it's the result of a calculation
of other values in the database. Design your tables so that each field is
atomic: contains only one form of data about a single attribute of the
current entity.

HTH
 
Top