VBA Conditional Formatting of a Field
Posted on 2006-11-16
I have a query that returns all orders. I run a report off that query that has an AuthString MEMO field. I only want the AuthString field in the report to be visible and change the font to red when a certain condition is met.
the valid authstring field looks like this (do not display on report):
"Auth: 00456, Transaction: 12345, 1: This transaction has been approved.; avs: Y; cvv: M"
The invalid data in the authstring field looks like this (display on report and turn RED):
Auth: , Transaction: , 1: There was a problem with this transaction.; avs: n; cvv: n
(notice no auth # or transaction # and the message is completely different)
When the report opens and shows ALL orders, for the invalid data I want to be able to display the whole AuthString field WHERE LIKE "*There was a problem with this transaction*" and change the color of the text to red.
do not display the AuthString field
Thanks for the help