Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
compare two fields in two subreports
1 view
Skip to first unread message
dtrk
Jan 15, 2011, 8:54:50 AM1/15/11
to
Dear Members, I have a db based on MsAccess 2003. I have a base report
combining two subreports in it. Can I compare a field in a subreport
with another field in the other subreport? If they are similar I want
to see these fields background color or font color in red. I wish to
write a code in Open Event of base report like this:
if reports!MyReport_A!MyField_X= reports!MyReport_B!MyField_Y then
MyReport_A!MyField_X.Backgroundcolor=255 MyReport_B!
MyField_Y.Backgroundcolor=255 endif
Is this possible ? As you see I am at very beginning in VB practice,
thanks in advance.
Ruhi
combining two subreports in it. Can I compare a field in a subreport
with another field in the other subreport? If they are similar I want
to see these fields background color or font color in red. I wish to
write a code in Open Event of base report like this:
if reports!MyReport_A!MyField_X= reports!MyReport_B!MyField_Y then
MyReport_A!MyField_X.Backgroundcolor=255 MyReport_B!
MyField_Y.Backgroundcolor=255 endif
Is this possible ? As you see I am at very beginning in VB practice,
thanks in advance.
Ruhi
0 new messages