Changing the ObjectName in a Formula

[mattbryant4]

Hi,

I am looking to change the name of a text object dependent on the value of another field for example

If Field 1 has a value 1 then Text object will display One
If Field 2 has a value 2 then Text object will display Trees

i have a basic knowledge of VB6 but nothing more than that

Please help

 

[MisterMo]

Sorry but does VB6 has to do with it?

are you passing parameters from a VB application?

Mo

 

[mattbryant4]

Sorry i was just noting what programming language i know, it has nothing to do with the formula

 

[MisterMo]

try this in a formula field

if {mytable.MyField} = 'Some Value' then
'display this text'
else if {mytable.MyField} = 'Some other Value then
'Display That'
else
'Nothing to display'

Mo

 

[MisterMo]

P.S.

try and be more descriptive, the more info you give the beter help you get.

eg Version of CR, Database, fields used and the likely outcome you would like to achieve

Mo

 

[mattbryant4]

Thanks for your help that code worked a treat, thanks for the advice i will try to be more descriptive in the future