On Format property in Report

[Guest]

I Created 2 forms with the background set to yellow. Form1 and Form2.

I created my report based on the 2 forms listed above.

When I go to print the report it prints the background in yellow. Well I
could always change the background back to white on the forms so I wont use
up all my color ink. Or I could ask what would be the VBA code to use on the
reports detail secion on format property. As a bonus (mabey asking to much)
In form1 and form2 I have a text box named myevent. If myevent = payday then
could I have it print payday in red. I looked at the other posts and didnt
find any simular postings. Thank.

 

[Steve Schapel]

BrianPaul,

I think if you open the report in design view, and then look at the
Properties for each section of the report, you can set the Back Color
property to white.

As for the red, again in design view, select the myevent textbox, and
then select Conditional Formatting from the Format menu. Select the
'Expression Is' option, and then type [myevent]=[payday] and set the
text colour to red.

 

[Guest]

BrianPaul,

I think if you open the report in design view, and then look at the
Properties for each section of the report, you can set the Back Color
property to white.

As for the red, again in design view, select the myevent textbox, and
then select Conditional Formatting from the Format menu. Select the
'Expression Is' option, and then type [myevent]=[payday] and set the
text colour to red.

--
Steve Schapel, Microsoft Access MVP

I Created 2 forms with the background set to yellow. Form1 and Form2.

I created my report based on the 2 forms listed above.

When I go to print the report it prints the background in yellow. Well I
could always change the background back to white on the forms so I wont use
up all my color ink. Or I could ask what would be the VBA code to use on the
reports detail secion on format property. As a bonus (mabey asking to much)
In form1 and form2 I have a text box named myevent. If myevent = payday then
could I have it print payday in red. I looked at the other posts and didnt
find any simular postings. Thank.

 

[Guest]

Majority of the report is white, However where the sub form is placed is
yellow.

BrianPaul,

I think if you open the report in design view, and then look at the
Properties for each section of the report, you can set the Back Color
property to white.

As for the red, again in design view, select the myevent textbox, and
then select Conditional Formatting from the Format menu. Select the
'Expression Is' option, and then type [myevent]=[payday] and set the
text colour to red.

--
Steve Schapel, Microsoft Access MVP

I Created 2 forms with the background set to yellow. Form1 and Form2.

I created my report based on the 2 forms listed above.

When I go to print the report it prints the background in yellow. Well I
could always change the background back to white on the forms so I wont use
up all my color ink. Or I could ask what would be the VBA code to use on the
reports detail secion on format property. As a bonus (mabey asking to much)
In form1 and form2 I have a text box named myevent. If myevent = payday then
could I have it print payday in red. I looked at the other posts and didnt
find any simular postings. Thank.

 

[Steve Schapel]

BrianPaul,

Sounds like you need to open the report that is being used as the
subreport, and also adjust the Back Color property there as well.

Off on a tangent, I guess, to your main question - but in general I
would advise against deriving a report design from a form design. For
one thing, the best report is often quite different in structure from
the best form for the same data.