• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 96
  • Last Modified:

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
1 Solution
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
=IIf(InStr(Field!PONumber.Value, "c") > 0, "Yes","No")
Haris DjulicCommented:

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

vbnetcoderAuthor Commented:
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now