Format on Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Again,

my posting screwed up

How do I format a row in my report to bold it based on on text boxes value.
Here's what I mean

If OrdinalHR = 30 then
Bold: OridinalHr, HighestHrDOW,HighestHrTime,MaxHr,KFactor

These are my text boxes on this report

Thanks in advance

G
 
1) You can use Conditional Formatting.
Set each control's Condition1 to:
Expression Is [OrdinalHR] = 30

Alternatively, code the Report Detail Format event:
If [OrdinalHR] = 30 then
[OridinalHR].FontBold = True
[HighestHRDOW].FontBold = True
etc.
Else
[OridinalHR].FontBold = False
[HighestHRDOW].FontBold = False
etc.
End If

PS. I notice you have an inconsistent spelling of
OrdinalHR (OridinalHR)!
 
Back
Top