Recent content by thabart

When I pulled the Vendor table into the query three times I had to give the field a unique name. So it showed the field name of "Company" twice. But when I changed the underlying query to read "Winner:[Vendor].[Company]" it then had a unique name to pull the value from.

I figured it out. Tim

I have a database that shows all proposals that my company is interested in bidding on or has already bid on. The tables are a header table, a proposal table, and a vendor table. The header table holds the proposal number, the customer ID, and the solicitation type. The proposal table holds the...

so the first group turns blue - like it should, the second group does not work, the third group turns red - like it should. Since it has to stop working after the first true case, how does it turn the third group red? Tim

My expectation is that the select case block will look compare each group to the first case and, if it is true then change the header background to the appropriate color, then check it against the second group and if it is true change the background color to green, then the third one and change...

Well, thank you for your efforts:-) Tim

I moved it there and got the same result.

I have it in the "On Load" event. I was not able to figure out conditional formatting for the header of the report.

It is a report, and it should, where the line of business is Commercial set the back color to blue, when Government set the back color to Green, and when Infrastructure Red.

I added it after each CASE statment and got My Value is :Commercial ! My Value is :Commercial ! My Value is :Government ! My Value is :Government ! My Value is :Government ! My Value is :Government ! My Value is :Infrastructure ! My Value is :Infrastructure ! My Value is :Commercial ! My Value...

I added that line and got an error of "Compile Error, Statements and labels invalid between Select Case and first Case"

I changed it to value instead of text and removed the Case "" Ran it again and got the same results Tim

Update: I just ran the report again and the second CASE worked but the third did not. I changed the code to change the font to work with the new colors Select Case Me.Line_of_Business.Text Case "" Case "Commercial" Me.GroupHeader0.BackColor = RGB(0, 0, 255)...

I have written a case statement in VBA to color code a report. The report is to show expiring contracts. Unfortunately, the CASE statement is not working right, it colors the first, third, and last correctly but not the second. Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As...