Conditional Formating with Access97

[lizI3]

Iam working with access97 and would like to format a field in a Report (the report is a main report with a sub report) based on a condition. I have 2 fields TransMain(on the main report) and TransNo (on the sub report). If transNo does not equal TransMain then I want TransNo to be Bold. I can do this very easily in access2000 but cannot get the code or even where to enter the code in access97. Would appreciate any help
Thanks Liz

 

[KenReay]

Hi

No promises, but have you tried in the onformat event of the section (ie detail?) where transno is:

If Reports!MyMainReport!TransMain = TransoNo Then
' set font of transno normal
Else
' set font of transno bold
End if
Regards

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

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

UK

 

[lizI3]

Thanks KenReay I think this will work.