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

Dynamically change value in textbox

The code below dynamically change the a label in data Report. How to dynamically change a textbox data in Data Report?

Me.Sections("section1").Controls("label1").Caption= "Hello"

1 Solution
Ryan ChongCommented:
What don't you update the DataSource of Data Report??
Ryan ChongCommented:
> What don't you update ..
"What" should be "Why"
Hi chwankok

Me.Sections("section1").Controls("Text1").Text = "Hello"

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

chwankokAuthor Commented:
It does not work and i tried this too
Me.Sections("section1").Controls.Item("Text1").Text = "Hello"

i have an if condition to determine what value to display.  

Ryan ChongCommented:
Isn't it what your display show in "Detail Section" ? What you intend to change > a field's value or free text value?

Sorry ! You can not change dynamically the value of text box in the data report but you can change the label caption !!! I think it is the drawback of Data report !!!

you can do this in the sql statement.
what database do you use?
for access db use the iif and or switch statement
IIf(expr, truepart, falsepart)

ex select iif(fieldA= 1,"Red","Green") as myfield from tablea

you may use the switch statement.
Switch(expr-1, value-1[, expr-2, value-2 … [, expr-n,value-n]])

ex select Switch([fielda]="1","one",[fielda]="2","two"",[fielda]>"2","other") AS myfield , FROM tablea

The problem with the switch statement is that the function returns a null if none of the conditions are found.  And sometimes it is difficult to have an other statement in this case use the iif and the switch together

SELECT iif(Switch([fielda]="1","one",[fielda]="2","two") is not null,Switch([fielda]="1","one",[fielda]="2","two"),"BLANKS" )AS myfield FROM tablea

chwankokAuthor Commented:
hi raama16, If what you said true, i will not waste more time on this. Thank you. =)
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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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