Search results

Thanks boblarson, that was the problem. (I'm not the best in VBA, but with google and how-tos I figured it out). Now this is more of a design question I guess, what would be the best way to achieve the following? Current setup: Report fields has 31 text boxes, each one cooresponds with day of...

Well for the most part, I've figured it out. Here's the code I am using Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Select Case Me.tisort Case "10" Select Case Text172 Case 0 To 4.9: SetBurntOrange Text172...

Thanks for the response. Another question would be when I'm building the If/Then statements, do I need to reference the textboxes in the report, or the Columns from the table (ie. If Me.Textbox1 or Me.Day1).

I'm sure this has been answered (matter of fact I'm still scouring the forums trying to find an example or the answer to what I'm looking for). Access 2003 as we all know has a limit of 3 conditional formatting options (4 if you count the default). I'm looking to add to this via some VBA code...