By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,928 Members | 1,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,928 IT Pros & Developers. It's quick & easy.

Datasheet formatting by date

P: n/a
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?
Jun 27 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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 ***
Jun 27 '08 #2

P: n/a
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" <sr*********@gmail.comwrote in message
news:f7**********************************@f63g2000 hsf.googlegroups.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?

Jun 27 '08 #3

P: n/a
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...@myfamilyname.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...@gmail.comwrote in message

news:f7**********************************@f63g2000 hsf.googlegroups.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?
Jun 27 '08 #4

P: n/a
Have a look at Stephen Lebans website

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

Think there will be something there to help you

Phil

"RussCRM" <sr*********@gmail.comwrote in message
news:a3**********************************@34g2000h sf.googlegroups.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...@myfamilyname.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...@gmail.comwrote in message

news:f7**********************************@f63g200 0hsf.googlegroups.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?

Jun 27 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.