Conditional Bold of Fields During Printing

[RangerFan]

What I would like to do is the following:

During the report exection I would like to change the font weight of a given report item, based on the value of another report item. This would be done on a line by line basis.

Example:

FIELD1 FIELD2 FIELD3
12345 ABCD (bold) XXXX
13446 ABCD XXXX
13678 ABCD XXXX
12345 ABCD (bold) XXXX
19445 ABCD XXXX

If FIELD1 = 12345 Then
the contents of FIELD2 (ABCD) is bolded
Else
the contents of FIELD2 (ABCD) is normal
End-If

I hope that makes sense, and as always, any help is greatly appreciated.

 

[KenReay]

In the onformat event of the detail line put your code

If FIELD1 = 12345 Then
FIELD2.fontweight = 700
Else
FIELD2.fontweight = 400
EndIf


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[RangerFan]

Thank you Ken. That worked perfectly.

 

[dhookom]

You should be able to do this without code. Try set the conditional formatting to
[tt][blue]
Expression Is:
[FIELD1] = 12345
[/blue][/tt]

Duane
Hook'D on Access
MS Access MVP