textbox calculation

[Guest]

Hiya

This one is an easy one I think, I'm a bit blank on it though
Trying to force a formula into a textbox in a report on open. It says I cannot assign a value to this object (run-time error 2448)

This the code on open

txtrefstatus = "=UCase(IIf([Referral status]='Returned to host',[Referral status],[Referral status] & ' Referrals'))

Do you know what I should be typing

Many thanks

Basil

 

[Alex Dybenko]

try:
txtrefstatus.controlsource = ...
or just caclulate this value in a code and then assign result

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Hiya,

This one is an easy one I think, I'm a bit blank on it though!
Trying to force a formula into a textbox in a report on open. It says I

cannot assign a value to this object (run-time error 2448).

This the code on open:

txtrefstatus = "=UCase(IIf([Referral status]='Returned to

host',[Referral status],[Referral status] & ' Referrals'))"