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

Report conditional formatting based on recordset comparison

P: n/a
My report is based off of a table. I need a record on the report to be
highlighted if that record ID is in a different table. Something like,
if record ID exists in Query X, then conditional format this entry on
the report.

Any suggestions?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
John, Could use something like this placed in the On Format event of the detail section in your
report (Air Code)

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim intX as Integer
intX = DCount("[recordID]", "RecordTable", "[recordID] = " & Me.recordID)

If intX > 0 Then
Me.Detail.BackColor = 65535
Else
Me.Detail.BackColor = 16777215
End If
End Sub

--
Reggie

----------
"John" <so*********@hotmail.com> wrote in message
news:90**************************@posting.google.c om...
My report is based off of a table. I need a record on the report to be
highlighted if that record ID is in a different table. Something like,
if record ID exists in Query X, then conditional format this entry on
the report.

Any suggestions?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.