How to assign values to Unbound Text box in Report thru VBA code ?

[Paul via AccessMonster.com]

I have a report with some Unbound text boxes. I want to shows the values in
these text boxes from my VBA code. How can I assign the valuse thru code ?
Pls help me.

--
Message posted via http://www.accessmonster.com

[rkc]

Paul via AccessMonster.com wrote:

I have a report with some Unbound text boxes. I want to shows the values in
these text boxes from my VBA code. How can I assign the valuse thru code ?
Pls help me.

Assign values to the textbox controls in the report's
Detail_Format event.

[lylefair]

Create a Public Function that returns the string you want to appear in
the text box.

eg.
Public Function MyFunction() As String
MyFunction="The Iraq War is illegal and immoral."
End Function

Set the ControlSource of the TextBox to
=MyFunction()

[rkc]

ly******@yahoo.ca wrote:

Public Function MyFunction() As String
MyFunction="The Iraq War is illegal and immoral."
End Function

I get a compiler error when I try this.

[lylefair]

I don't know what to say. I have been using this kind of assignment for
a long time, back to Access 95. At that time I had an extensive charity
receipt/thanks writing report which selected text depending on type of
membership, type of donation etc.

I just double checked in Access 2002 and up pops:

The Iraq War is illegal and immoral.

Could it be God speaking, and not the report at all?

[Thelma Lubkin]

ly******@yahoo.ca wrote:
: Create a Public Function that returns the string you want to appear in
: the text box.

: eg.
: Public Function MyFunction() As String
: MyFunction="The Iraq War is illegal and immoral."
: End Function

: Set the ControlSource of the TextBox to
: =MyFunction()

How do you adapt this for the array needed by a combobox?
thanks, --thelma

[rkc]

ly******@yahoo.ca wrote:

I don't know what to say.

It was comedy my friend from the north.

[lylefair]

A Combo Box's value should be able to be set just like a that of a
TextBox.

For my preferred way to set a ComboBox's list in code see
http://groups.google.ca/group/comp.d...d80edcea8a1598
and the two immediate children of that post.
Other developers will have other preferred ways.