Function as a control source?

  • Thread starter Thread starter LAS
  • Start date Start date
L

LAS

I have a text box and have put in the Control Source property "=
fncProblemName("4")" This function should return "Staying on Task", but
the text box appears empty. If I try to type in it, though, each keystrok
produces a little bell and nothing is typed. A break in the function code
is not executed.

On the other hand, if I put txtBox = fncProblemName("4") in the OnLoad event
of the form, the break point is executed and the return value shows up.

Can anyone tell me what I'm doing wrong in my use of the Control Source?
 
Double up the " characters that delimit the argument for the function:

Control Source property "= fncProblemName(""4"")"
 
Double up the " characters that delimit the argument for the
function:

Control Source property "= fncProblemName(""4"")"
Click to expand...

....or just use single quotes:

"= fncProblemName('4')"

It only matters if you're passing a parameter that's based on a data
field that might have an apostrophe in it.
 
Thanks to both of you!

David W. Fenton said:
...or just use single quotes:

"= fncProblemName('4')"

It only matters if you're passing a parameter that's based on a data
field that might have an apostrophe in it.
Click to expand...
 
Back
Top