Can't assign value to control

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

Guest

I have text boxes on my report named Y1 thru Y4
When I try to assign values to them during the 'report open' event, I get a
message 'can't assign value to this variable'. I'm using Me.Y1 =

Another question, the table my report is based on contains numbers 1 thru 6
in a set of columns. These must be printed as different background colors on
the report. What is the best report event to do this?
 
mscertified,

Controls are not accessible in OnOpen event of a form. Try the OnFormat
event of the detail section.

HTH,
Josh
 
mscertified said:
I have text boxes on my report named Y1 thru Y4
When I try to assign values to them during the 'report open' event, I get a
message 'can't assign value to this variable'. I'm using Me.Y1 =

Another question, the table my report is based on contains numbers 1 thru 6
in a set of columns. These must be printed as different background colors on
the report. What is the best report event to do this?
Click to expand...


You can not assign values in the Open event. Try using the
report header's format event instead.

The Format event of the section containing the controls is
the standard place to manipulate the control's properties.
 
Back
Top