I want to give a text box values based on the value a field. How would i do so?

For example if Field!PONumber  contains a c i want it to show one set of text otherwise i want it to show other text
vbnetcoderAsked:
Who is Participating?
 
Haris DulicConnect With a Mentor Commented:
HI,

where is this textbox? if you are bulding SQL for report you can use CASE function like this

Select ( case when Field!PONumber like '%c%' then 'TEXT' else 'TEXT2' end) as textbox_text

Open in new window

0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
=IIf(InStr(Field!PONumber.Value, "c") > 0, "Yes","No")
0
 
vbnetcoderAuthor Commented:
ty
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.