Modifying a text box on a report

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

Guest

How do I go about modifying a text box on a report so that when I click on
print preview for the report it will display the text I specify in code.

An additional question. I want to access the next record in the recordset
for the report and place one of the fields values in a text box. How can I
accomplish this? I tried creating a Recordset Object and setting it to
Reports("VAACase03a").Recordset but I get an error saying this is not allowed
in an .mdb file?

- Tom
 
For the control source you should use a function

=GetValueFromCode()

where the function is something like
global gMyValue as string

public function GetValueFromCode() as string
GetValueFromCode=gMyValue
end function

or

public function GetValueFromCode() as string
GetValueFromCode=Forms!MyForm!MyControl
end function

- Raoul
 
Back
Top