Access and VBA: change report text from report code

Question

in my Access application I have a form and a report. In the form I have my textBoxForm, in the report I have my textBoxReport. Normally, in the textBoxReport I see the textBoxForm value. How can I set dynamically from the report VBA-code the value of the textReport? For example, I want that, if the value in the textForm is 1, the value in the textReport is "ok".

I have already searched a solution in internet, but in all cases I see always an error similar to 'impossible set this value for this element'.

Thank you!

Wayne G. Dunn · Accepted Answer · 2017-03-10 17:41:48Z

1

Does your report use a query? If so, you would just place an 'IIF' in the query that tests for the value you want to change, then either changes it to something else, or retains the original value. The below will test field 'Nbr1' for the presence of a 1, and if found, change it to 'OK', otherwise it stays the same.

Note! You will need to change the control source in the report to reflect the name you provide (i.e. 'MyChange') because you can't keep the original name.

SELECT Table1.ID, Table1.EMPID, Table1.TestResult, 
   IIf([Nbr1]=1,"OK",[Nbr1]) AS MyChange, Table1.Nbr2
   FROM Table1;

answered Mar 10, 2017 at 17:41

Wayne G. Dunn

4,3322 gold badges15 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Archimede Over a year ago

Thank you very much, this is an alternative way to solve my problem.

Collectives™ on Stack Overflow

Access and VBA: change report text from report code

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related