Assigning a value to a textbox

[monrosal]

Does anybody know how I can program the value of a textbox in a report?

See what I have is a textbox that calls a control source from a field in the database. That field is a numeric field ranging from 1-3. What I want to do is for each value that is 1 the textbox = "test1" and for each value that is 2 the textbox = "test2". Is there a loop function I can use?

Thanks for your help

Ramon

 

[MichaelRed]

=Choose([Fieldname, "Test1", "Test2", "Test3&quot

Or

= "Test" & Trim(Str([FieldName])



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over