Printing reports PAIN

[Guest]

Okay, I'm sure its a common problem but when I print a report based on a
table that is using other tables as a source file (example: I have a table
employees and on project table I have the source for the employee names on
the project as a combo box looking at the employee table). When I generate a
report from this project table the fields that were combo boxes are printed
with white text and black background, how do I get rid of this so these
fields look like the rest in the report?

Lori A. Pong

 

[Guest]

You can use code to change the properties of the controls containing the
fields to assign back and fore colors. I use the color number equivalents.

ControlName.BackColor = -2147483633
LabelName.Caption = "You are in View Mode."

This code assigns standard gray to the control when user is in View mode.

HTH
scruffy

 

[Duane Hookom]

Make sure the tables/fields with the actual values are included in your
report's record source so you can use text boxes.

 

[Guest]

Okay, I'm not sure where I need to make this change. Do I change each item
where the problem exists (in one report there is three separate items that
come up black) or do I change it in the report settings itself?

 

[Larry Linson]

Okay, I'm sure its a common problem but when I print a report based on a
table that is using other tables as a source file (example: I have a table
employees and on project table I have the source for the employee names on
the project as a combo box looking at the employee table). When I
generate a
report from this project table the fields that were combo boxes are
printed
with white text and black background, how do I get rid of this so these
fields look like the rest in the report?

By "fields that were combo boxes," do you mean you defined LookupFields in
your Tables? If so, I advise you to get rid of them, and use LookupTables,
instead. Combo Boxes are for user interaction, and Reports are not
Interactive.

On the other hand, if you do not want to go to that much trouble, just open
the Reports in Design View, click on the Control to highlight it, then on
the Menu, Format | ChangeTo and select TextBox. That will replace the
useless Combo Box with a Text Box.

Larry Linson
Microsoft Access MVP

 

[Guest]

Perfect, I used the format/change to option and it works perfectly. Thanks