Bolding Individual Records in Access 97?

[Guest]

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?

 

[Douglas J. Steele]

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?

Unfortunately, no.

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

 

[tina]

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

Unfortunately, no.

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

 

[Douglas J. Steele]

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

 

[tina]

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

 

[Dale Fye]

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