Formula in a Text Box

[AccessHelp]

Hello all,

I have 2 sheets (Sheet 1 and Sheet 2) in my workbook. In Sheet 2, I want to
create a text box, and I want the text box to show the student name (e.g.
Student Name - Joe Smith) from Sheet 1.

So I type in the formula (="Student Name - " & 'Sheet 1'!A1) in the Text
field properties of the the text box. Some how, the text box shows the
formula, instead of "Student Name - Joe Smith" (Joe Smith is a value in A1 of
Sheet 1).

Please help.

Thanks.

 

[Gary''s Student]

1. put the formula in a cell
2. copy the cell's value to the textbox

 

[AccessHelp]

Hi Gary's Student,

Thanks for your response.

I tried as you instructed, and I got a text box with value.

Is there a way I can make the dynamic text box, instead of static text box?
What I mean is when the student name changes in Cell A1 of Sheet1, the change
will reflect in the text box.

Thanks.