I am trying to create a report and it is working except for the fact that
some of the data is printed in white with a black background and some of the
data is printed in black but has a thin border box around it. I have (I
think) made the borders transparent and hairline but they still appear.

The data for the report comes from a query and the fields that are printing
as described come from tables that have a drop-down selection box so there
must be a relationship.

How can I get rid of the borders and the black background?

Thank you,
David Vollmer

What kind of controls are you adding to your report? If you are dragging a
combo-box to your report, then right click it and select the "change to"
option and make it a text box.

Most of the "fancy" control types are great for interactive user forms, but
a report is really just there to print on paper. Text Boxes (bound or
unbound) will do 99% of what you want on a report.


--
Rick B



"David Vollmer" <(E-Mail Removed)> wrote in message
news:8BB7E831-672B-493D-90FA-(E-Mail Removed)...
>I am trying to create a report and it is working except for the fact that
> some of the data is printed in white with a black background and some of
> the
> data is printed in black but has a thin border box around it. I have (I
> think) made the borders transparent and hairline but they still appear.
>
> The data for the report comes from a query and the fields that are
> printing
> as described come from tables that have a drop-down selection box so there
> must be a relationship.
>
> How can I get rid of the borders and the black background?
>
> Thank you,
> David Vollmer

David Vollmer wrote:

>I am trying to create a report and it is working except for the fact that
>some of the data is printed in white with a black background and some of the
>data is printed in black but has a thin border box around it. I have (I
>think) made the borders transparent and hairline but they still appear.
>
>The data for the report comes from a query and the fields that are printing
>as described come from tables that have a drop-down selection box so there
>must be a relationship.
>
>How can I get rid of the borders and the black background?


It sounds like those fields are using combo box controls in
the report.

Try changing them to text boxes and see what that produces.
I suspect that the format will be ok, but you may see
numbers instead of names. If this happens then you need to
modify the report's record source to be a query that joins
the lookup tables to you you main tables to make the names
available to the report.

--
Marsh
MVP [MS Access]

Thank you Rick and Marshall. The change to text box did the trick!

"Marshall Barton" wrote:

> David Vollmer wrote:
>
> >I am trying to create a report and it is working except for the fact that
> >some of the data is printed in white with a black background and some of the
> >data is printed in black but has a thin border box around it. I have (I
> >think) made the borders transparent and hairline but they still appear.
> >
> >The data for the report comes from a query and the fields that are printing
> >as described come from tables that have a drop-down selection box so there
> >must be a relationship.
> >
> >How can I get rid of the borders and the black background?
>
>
> It sounds like those fields are using combo box controls in
> the report.
>
> Try changing them to text boxes and see what that produces.
> I suspect that the format will be ok, but you may see
> numbers instead of names. If this happens then you need to
> modify the report's record source to be a query that joins
> the lookup tables to you you main tables to make the names
> available to the report.
>
> --
> Marsh
> MVP [MS Access]
>