Re: Color subreport fields need big help!
- From: Mac Moull <Mac Moull@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 5 Aug 2008 03:55:00 -0700
Guys - I think I might have solved your problem. I too was having trouble
getting the code to work, until I realised the Back Style for the field was
set to 'Transparent'. as soon as I reset it to 'Normal' it worked !!
Hope I've helped you, because your thread certainly helped me in the first
place.
"Ben" wrote:
Marshall,.
It seems as if the Me.PreviousStatus.BackColor is not a valid call in the
report on Format event. Is there a way I can code the conditional
formatting? I don't want to use the normal conditional formatting because i
have multiple conditions.
Just a thought. This little problem is being a pain.
Ben
"Marshall Barton" wrote:
Ben wrote:
There is a form called Builds. The fields PreviousStatus and CurrentStatus
are combo boxes that have a list of values Blue, Green, Yellow, Red, Purple,
Gold, and N/A. When the user clicks on the drop down menu and selects one of
those values, the background of the combo box changes to that color. If N/A
is selected then it's white. Those values are stored in the table.
There is a main report called rptWAR that has a subreport based on the data
from the Builds table. I can get the data to publish on the subreport, but
the back color of each of these values does not show the color.
When I look at the design view of the subreport I see the combo boxes on the
report. I clicked on the Details section and went to Event, On Format. I
entered the code you provided me the Select Case statement and I don't see
any colors. I wish I could email you the database because it'll be easier
that way. My email is ronen.ben@xxxxxxxxx if you need that.
The form is irrelevant at this point. It also sound like
the main report has no involvement so try opening the
subreport by itself. We only care about the subreport's
report's record source table/query and what's in the
subreport.
You're using a combo box on a report??? That would be very
odd if true. I'm beginning to think that your table field
is a Lookup Field (displayed as a drop list), which will
totally obscure what is really going on. If so, change it
to a text box and post back with what happened. I suspect
that the value in the field could be something other than
"Blue", "Red" or ...
--
Marsh
MVP [MS Access]
- Prev by Date: Re: Drawing horizontal lines in Detail Area (Access 2003 xp sp3)
- Next by Date: displaying a report
- Previous by thread: HELP--how do you select fields show in report based on opened form?
- Next by thread: displaying a report
- Index(es):
Relevant Pages
|
