Greenbar

  • Thread starter Thread starter Doug Sanders
  • Start date Start date
D

Doug Sanders

I have a form with a lot of data that is not the easiest to read.

Is there a way to create/emulate the output of greenbar printouts?

Thanks,
Doug
 
Doug Sanders said:
I have a form with a lot of data that is not the easiest to read.

Is there a way to create/emulate the output of greenbar printouts?
Click to expand...

I'm not sure, but I think there may be an example of this in either the
Northwind or Solutions sample database. I know I've seen it somewhere.
I don't remember what was done then, but I'd think you could accomplish
this pretty easily like this:

1. Putting a small text box in the report's detail section, with these
properties:

Name: txtCounter
Visible: No
Control Source: =1
Running Sum: Over All

2. Create an event procedure for the Format event of the form's Detail
section, like this:

'----- start of code -----
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If Me!txtCounter Mod 2 = 1 Then
Me.Detail.BackColor = 16777215
Else
Me.Detail.BackColor = 12632256
End If

End Sub

'----- end of code -----

That ought to do it, or at least be a start.
 
Thanks,

I will look at Northwind and your sample looks workable too.

Thanks for the quick response.

Doug
 
If your form is a continuous form, you can alternately color the rows using
conditional formating under Format.
 
PC Datasheet said:
If your form is a continuous form, you can alternately color the rows
using conditional formating under Format.
Click to expand...

Y'know, your message just made me realize that Doug was asking about a
form, not a report. What was I thinking? Doug, the solution I
suggested will only work for a report, not a form. Steve (PC Datasheet)
has the right idea, if you're using a form.
 
Every once in a while I do the same thing when reading and then answering
posts here.

Thanks for the compliment!

Steve
 
Back
Top