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"

chwankokAsked:
Who is Participating?
 
raama16Commented:
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 !!!

Regards,
Ramachandra
0
 
Ryan ChongCommented:
What don't you update the DataSource of Data Report??
0
 
Ryan ChongCommented:
> What don't you update ..
"What" should be "Why"
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
SirNickCommented:
Hi chwankok
Try

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

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

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

0
 
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?

regards
0
 
jdesharnaisCommented:
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

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