Bolding Individual Records in Access 97?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

39steps@earthlink.net - 23 Sep 2007 00:08 GMT

To start, I'm a non-developer and non Virtual Basic programmer, so this is
realy an amateur's question:

I've created a nice database of films I've collected on VHS and transferred
to DVD-R, and a functional report that sorts and lists them by genre, e.g.,
action, comedy, drama, horror, etc.

I've separated the various types simply by creating a field with the letter
expressions "a", "b", etc, and used a slo record in, e.g., "a" to, under the
field, "Title"-which is the leftmost column in my report-"Action,
Adventure".

Unfortunately it does not appear that I can select individual records like
the one, above, to bold so the separate genres will stand out in a list of
over 700 films. I've read and re-read the grouping instructions in the help
file and in the hard copy of the manual (one of the last ones printed, I
would guess), and can't seem to apply the jatrgon-loaded directions.

Other than upgrading to a later Access version that provides for conditional
formatting, is there a non-programming answer for my task?

Reply to this Message

Douglas J. Steele - 23 Sep 2007 12:46 GMT

> Unfortunately it does not appear that I can select individual records like
> the one, above, to bold so the separate genres will stand out in a list of
[quoted text clipped - 5 lines]
> Other than upgrading to a later Access version that provides for
> conditional formatting, is there a non-programming answer for my task?

Unfortunately, no.

What version of Access are you using? Conditional Formatting was introduced
in Access 2000.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Reply to this Message

tina - 23 Sep 2007 15:31 GMT

he's using A97, hon, per the Subject line.

> > Unfortunately it does not appear that I can select individual records like
> > the one, above, to bold so the separate genres will stand out in a list of
[quoted text clipped - 10 lines]
> What version of Access are you using? Conditional Formatting was introduced
> in Access 2000.

Reply to this Message

Douglas J. Steele - 23 Sep 2007 16:24 GMT

So he is. Once I'm in the body of the post, I seldom think to look back to
the subject line.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> he's using A97, hon, per the Subject line.
>
[quoted text clipped - 15 lines]
> introduced
>> in Access 2000.

Reply to this Message

tina - 23 Sep 2007 22:18 GMT

me, too - ithis one just happened to catch my eye. :)

> So he is. Once I'm in the body of the post, I seldom think to look back to
> the subject line.
[quoted text clipped - 18 lines]
> > introduced
> >> in Access 2000.

Reply to this Message

Dale Fye - 24 Sep 2007 20:10 GMT

I'm not sure I understand what it is you are trying to do.

I think, that in a report, you want to make a distinct change in the
formatting of a control on a report whenever the value in that control
changes (an your report is grouped by that control). Is that accurate?

If this is the case, you might want to try using the Format event of your
group header to implement code similar to the following. I normally use this
technique in the details section of a report to alternate row colors to make
it easier to read the report, but the same technique applies to group headers.

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)

Dim mycolor(2) As Long
Static GroupCount As Integer, GroupValue As Variant

mycolor(0) = 16777215
mycolor(1) = 14211288

If GroupValue <> Me.txt_Primary_Group Then
GroupCount = GroupCount + 1
GroupValue = Me.txt_Primary_Group
Me.Detail.BackColor = mycolor(GroupCount Mod 2)
End If

End Sub

HTH
Dale
-----
Email address is not valid.
Please reply to newsgroup only.

> To start, I'm a non-developer and non Virtual Basic programmer, so this is
> realy an amateur's question:
[quoted text clipped - 16 lines]
> Other than upgrading to a later Access version that provides for conditional
> formatting, is there a non-programming answer for my task?

Reply to this Message