Conditional Formating with access 97

[Liz_I3]

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

 

[Tanis]

Unfortunately, Access97 does not have any conditional formatting. So, you have to put some code in the On Format event procedure in the detail section of the report.
Something like this should work. I have tried it out on my machine an it works a treat.

If (Reports![TransMain]![TransNo].Report![TransNo]) <> (Reports![TransMain]![TransMain]) Then
Reports![TransMain]![TransNo].Report![TransNo].FontBold = True

Make sure you get the syntax right. The syntax is:

Reports![main report name]![subreport control name].Report![Control name]

David

 

[Liz_I3]

David thank you very much, this is a big help I was quit lost as to were to even put the code.

thanks agian
Liz