I have from in my DB that has a subform som of the textbox controls are referred to in code and the properties set such as .Format to set the format to the currency or euros depending upon the select currency by the user. This works great , But now I had saved thai form as a report but the references to the controls don't work, I have changed them to "Report" instead of "Form" in the code, but nothing works, All I get is error messages saying "VB cannot assign value" or "Cannot find field",
Sample below refers to the control "Currency" on the open form "confirm booking" if its value is "Euros" then the "Cost" control .format is set to "Euros", this works OK on the form but not on the report ??????

If (Forms![Confirm booking]!Currency = "euros") Then
Reports![confirm booking fax]![confirm booking fax subreport]![sum due].Format = "Euro"
Reports![confirm booking fax]!cost.Format = "Euro"
Else
Reports![confirm booking fax]!cost.Format = "currency"
Reports![confirm booking fax]![confirm booking fax subreport]![sum due].Format = "currency"
End If