asked on

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"

Ryan Chong

What don't you update the DataSource of Data Report??

Ryan Chong

> What don't you update ..
"What" should be "Why"

SirNick

Hi chwankok
Try

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

chwankok

ASKER

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.

Ryan Chong

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

regards

ASKER CERTIFIED SOLUTION

raama16

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jdesharnais

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

chwankok

ASKER

hi raama16, If what you said true, i will not waste more time on this. Thank you. =)