Greenbar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Doug Sanders - 05 Apr 2005 03:50 GMT

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

Reply to this Message

Dirk Goldgar - 05 Apr 2005 04:11 GMT

> 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?

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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Doug Sanders - 05 Apr 2005 04:18 GMT

Thanks,

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

Thanks for the quick response.

Doug

> > I have a form with a lot of data that is not the easiest to read.
> >
[quoted text clipped - 30 lines]
>
> That ought to do it, or at least be a start.

Reply to this Message

PC Datasheet - 05 Apr 2005 04:43 GMT

If your form is a continuous form, you can alternately color the rows using
conditional formating under Format.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

> 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

Reply to this Message

Dirk Goldgar - 05 Apr 2005 04:46 GMT

> If your form is a continuous form, you can alternately color the rows
> using conditional formating under Format.

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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

PC Datasheet - 05 Apr 2005 09:09 GMT

Every once in a while I do the same thing when reading and then answering
posts here.

Thanks for the compliment!

Steve

> > If your form is a continuous form, you can alternately color the rows
> > using conditional formating under Format.
[quoted text clipped - 9 lines]
>
> (please reply to the newsgroup)

Reply to this Message