Datasheet formatting by date

[RussCRM]

I have a subform in datasheet form with the fields Date, Type and Note
(sorted by Date). There are 4-5 records generally per date. Is there
a way to group them visually somehow by date such as alternating
colors/shading per date or a bold line between groups of records of a
particular date.

Any ideas?

[Rich P]

Re: Datasheet formatting by date

I don't know of a way to add colors to rows in a datasheet view in
Access. This is doable in a VB.Net datagridview (the .net equivalent of
a subform in datasheet view).

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Phil Stanton]

Re: Datasheet formatting by date

Two thoughts

1) Use a contionuous form. Can be made to look like a datasheet but allows
formatting
2) As there are presumably an unknown number of dates, you are going to need
an unknown number of colours, so that option is not on.
3) Try experimenting with a line whose visibility is changed by setting it
to False for the same date and True for a different date

Phil


"RussCRM" <srusskinyon@gm ail.comwrote in message
news:f765b12d-ca56-4582-9e11-7e361b44b4b3@f6 3g2000hsf.googl egroups.com...

>I have a subform in datasheet form with the fields Date, Type and Note
(sorted by Date). There are 4-5 records generally per date. Is there
a way to group them visually somehow by date such as alternating
colors/shading per date or a bold line between groups of records of a
particular date.
>
Any ideas?

[RussCRM]

Re: Datasheet formatting by date

Thanks for the help guys!

Realistically, I would be happy with two shades of gray just to
distinguish between different dates. Like, the most recent date would
be white, the next set of entries with a different date would be gray,
the next set white, etc. Sort of like alternating rows, only that I
want the color to change when it hits a different date. So some kind
of code that would look at a record's date, evaluate if its the same
or different, if it's different, set the row to the alternate color,
go to the next row, evaluate, change if, etc...

Could I do this with the True/False thing you suggested Phil? or is
there another way?



On Jun 18, 8:04 am, "Phil Stanton" <p...@myfamilyn ame.co.ukwrote:

Two thoughts
>
1) Use a contionuous form. Can be made to look like a datasheet but allows
formatting
2) As there are presumably an unknown number of dates, you are going to need
an unknown number of colours, so that option is not on.
3) Try experimenting with a line whose visibility is changed by setting it
to False for the same date and True for a different date
>
Phil
>
"RussCRM" <srusskin...@gm ail.comwrote in message
>
news:f765b12d-ca56-4582-9e11-7e361b44b4b3@f6 3g2000hsf.googl egroups.com...
>

I have a subform in datasheet form with the fields Date, Type and Note
(sorted by Date). There are 4-5 records generally per date. Is there
a way to group them visually somehow by date such as alternating
colors/shading per date or a bold line between groups of records of a
particular date.

>

Any ideas?

[Phil Stanton]

Re: Datasheet formatting by date

Have a look at Stephen Lebans website

http://www.lebans.com/conditionalformatting.htm

Think there will be something there to help you

Phil

"RussCRM" <srusskinyon@gm ail.comwrote in message
news:a36cb8eb-74e1-4894-ac70-c4dad2a64024@34 g2000hsf.google groups.com...

Thanks for the help guys!
>
Realistically, I would be happy with two shades of gray just to
distinguish between different dates. Like, the most recent date would
be white, the next set of entries with a different date would be gray,
the next set white, etc. Sort of like alternating rows, only that I
want the color to change when it hits a different date. So some kind
of code that would look at a record's date, evaluate if its the same
or different, if it's different, set the row to the alternate color,
go to the next row, evaluate, change if, etc...
>
Could I do this with the True/False thing you suggested Phil? or is
there another way?
>
>
>
On Jun 18, 8:04 am, "Phil Stanton" <p...@myfamilyn ame.co.ukwrote:

>Two thoughts
>>
>1) Use a contionuous form. Can be made to look like a datasheet but
>allows
>formatting
>2) As there are presumably an unknown number of dates, you are going to
>need
>an unknown number of colours, so that option is not on.
>3) Try experimenting with a line whose visibility is changed by setting
>it
>to False for the same date and True for a different date
>>
>Phil
>>
>"RussCRM" <srusskin...@gm ail.comwrote in message
>>
>news:f765b12 d-ca56-4582-9e11-7e361b44b4b3@f6 3g2000hsf.googl egroups.com...
>>

>I have a subform in datasheet form with the fields Date, Type and Note
(sorted by Date). There are 4-5 records generally per date. Is there
a way to group them visually somehow by date such as alternating
colors/shading per date or a bold line between groups of records of a
particular date.

>>

Any ideas?

>