How do I get rid of black background in report field

[Woodsy]

I am trying to create a report using a select query as the data source. All
of the fields that are based on a combo box in the original table show up in
the report highlighted (white letters on a black background). How do I get
them to show as black on white?

I am using Access 2003

 

[Duane Hookom]

Or, get rid of the combo boxes in favor of adding any lookup tables to your
report's record source and using text boxes bound to the appropriate fields.

 

[Woodsy]

The controls for the fields in question are already set for white background
and black foreground. Everrything looks fine in design view, but when you
move to preview mode, you get the highlighted 'negative' effect.

I believe it has something to do with the data being the "selected option"
in the combo box based on the original table, but it shouldn't show up that
way in a report.

 

[Woodsy]

Thanks Duane, That did it. I had just dragged and droopped from the field
list as I have done many times before without a problem. I'll have to watch
thaqt in the future. Specifying a text box and then binding it to the combo
box field gets rid of the negative effect.

Thanks again.

 

[Duane Hookom]

It seems like you might be using lookup fields in your tables. Consider
reading http://www.mvps.org/access/lookupfields.htm.