advanced conditional formatting

[dreamdelerium]

hey everyone. im trying to create a control that, when the report is opened, will change text according to a condition. example:
on my report i have a group header. if the group header's text equalls "11" i want the text/caption to be changed to "Lobatse District". ive seen that you can change text color and format.

thanks
jason

access 2003
vista

 

[namliam]

Sounds like you just need a related table to 'translate' 11 into "Lobatse District".

This is NOT conditional formatting.