unbound control Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All please I need your assistant..
this problem is driving me crazy..
I want to know how to set a control value to zero in case its source in some
other sub forms is not avilable. I don't want the control to show me #Error I
want to have its value as 0.
Thanks in advacne.
Paul.
 
You can try IsError() function, write in control source:

=IIF(IsError(Forms!MyForm!MyControl),0,Forms!MyForm!MyControl)
 
Dear Alex,
thanks for your support...
I tried the function but I was not able to apply it, it was saying error
like coma or something is missing anyway I created another controls in the
form where it can read from the sub form and I applied to my controls the
function to avoid going for subform in all cases my syntax was as follow
=IIF(IsError(OBC1),0,OBC1) but it was not working....
what shall i do to correct this syntax line... do i need to use [] i tried
them but still i was getting coma or missing brackets error.
I aprreciate your help.
 
Dear Alex..
You are Braliant..
The code from here doesn't work with me but I went to your website, and I
used another Code from there which is nnz function created for controls
Errors to retrive value to 0 that code was very good and I used it with so
many controls where its so flexible...
thank you very much for your website and your assistance.
Paul.


Paul said:
Dear Alex,
thanks for your support...
I tried the function but I was not able to apply it, it was saying error
like coma or something is missing anyway I created another controls in the
form where it can read from the sub form and I applied to my controls the
function to avoid going for subform in all cases my syntax was as follow
=IIF(IsError(OBC1),0,OBC1) but it was not working....
what shall i do to correct this syntax line... do i need to use [] i tried
them but still i was getting coma or missing brackets error.
I aprreciate your help.



Alex Dybenko said:
You can try IsError() function, write in control source:

=IIF(IsError(Forms!MyForm!MyControl),0,Forms!MyForm!MyControl)
Click to expand...
Click to expand...
 
Thank you Paul, you made me happy!
:-)

Alex

Paul said:
Dear Alex..
You are Braliant..
The code from here doesn't work with me but I went to your website, and I
used another Code from there which is nnz function created for controls
Errors to retrive value to 0 that code was very good and I used it with so
many controls where its so flexible...
thank you very much for your website and your assistance.
Paul.


Paul said:
Dear Alex,
thanks for your support...
I tried the function but I was not able to apply it, it was saying error
like coma or something is missing anyway I created another controls in
the
form where it can read from the sub form and I applied to my controls the
function to avoid going for subform in all cases my syntax was as follow
=IIF(IsError(OBC1),0,OBC1) but it was not working....
what shall i do to correct this syntax line... do i need to use [] i
tried
them but still i was getting coma or missing brackets error.
I aprreciate your help.



Alex Dybenko said:
You can try IsError() function, write in control source:

=IIF(IsError(Forms!MyForm!MyControl),0,Forms!MyForm!MyControl)

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


All please I need your assistant..
this problem is driving me crazy..
I want to know how to set a control value to zero in case its source
in
some
other sub forms is not avilable. I don't want the control to show me
#Error I
want to have its value as 0.
Thanks in advacne.
Paul.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top