Hi
I have linked a Visio 4.5 drawing to Access 97. A master shape has many text fields that display parts of the linked access record. Using VBA I want to step through all the shapes on the page and change the color of the text field (change text color is fine also) based on the value. For example if the text field displaying status equals finished I want that field to be green or if it is working then yellow. Can anyone point me in the right direction? Thanks in advance.
I have linked a Visio 4.5 drawing to Access 97. A master shape has many text fields that display parts of the linked access record. Using VBA I want to step through all the shapes on the page and change the color of the text field (change text color is fine also) based on the value. For example if the text field displaying status equals finished I want that field to be green or if it is working then yellow. Can anyone point me in the right direction? Thanks in advance.