Setting ControlSource on textbox in report

Question

In my report why is it that when I set the ControlSource on a textbox in a report to a field name like this: txtSomeTextBox.ControlSource = [Expr1] it populates as expected but when I define a user defined function like this:

Public Function GetString(strValues As String) As String
GetString = "Values: " & strValues
End Function

Then set the ControlSource property to txtSomeTextBox.ControlSource = GetString([Expr1]) it doesn't know what to do! In fact the textbox displays: "#Type!" Why can't I pass the value of [Expr1] to the function?

Andre · Accepted Answer · 2015-11-11 07:43:37Z

1

You need a = to evaluate a function.

=GetString([Expr1]) as controlsource works for me.

answered Nov 11, 2015 at 7:43

Andre

27.7k7 gold badges43 silver badges85 bronze badges

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

4 Comments

Alan Over a year ago

I'm thinking that [Expr1] is not a String but some other data type?

Andre Over a year ago

@Alan: Then try Public Function GetString(varValues As Variant) As String

Alan Over a year ago

Tried it. I get run time error: You entered an expression that has no value.

Alan Over a year ago

I found the problem. The name of the textbox had a circurlar reference to itself. Its name was the same as the field name. I renamed the textbox to txtAllValues and that fix it.

Collectives™ on Stack Overflow

Setting ControlSource on textbox in report

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related