Please help me, I have hit a massive wall again.
I am writing an estimation program and am having a
run-time error 438 (Object does not support this property or Method).
On the estimation form is a command button whose on click event holds
the command to open the Report
DoCmd.OpenReport "Rpt_Estimate", acViewNormal, , , , "DISP_ID"
The recordsource of the report is a table
And on the "On format event" of the detail section which is made up of text
boxes I am trying to print blanks when there are no more records by making
the forecolor of the Text boxes white but get the run-time error on the
first line below
Me!PartName.ForeColor = vbWhite ' Error on this line
Me!DrawingNo.ForeColor = vbWhite
Me!SIZE.ForeColor = vbWhite
Me!Qty.ForeColor = vbWhite
Me!Price.ForeColor = vbWhite
Me!Amount.ForeColor = vbWhite
Me!Miscellanous.ForeColor = vbWhite
I have looked thorougly but can't figure out what the problem is.
I don't think it matters but it should be noted the field names and
name of the Text boxes are the same.
I am writing an estimation program and am having a
run-time error 438 (Object does not support this property or Method).
On the estimation form is a command button whose on click event holds
the command to open the Report
DoCmd.OpenReport "Rpt_Estimate", acViewNormal, , , , "DISP_ID"
The recordsource of the report is a table
And on the "On format event" of the detail section which is made up of text
boxes I am trying to print blanks when there are no more records by making
the forecolor of the Text boxes white but get the run-time error on the
first line below
Me!PartName.ForeColor = vbWhite ' Error on this line
Me!DrawingNo.ForeColor = vbWhite
Me!SIZE.ForeColor = vbWhite
Me!Qty.ForeColor = vbWhite
Me!Price.ForeColor = vbWhite
Me!Amount.ForeColor = vbWhite
Me!Miscellanous.ForeColor = vbWhite
I have looked thorougly but can't figure out what the problem is.
I don't think it matters but it should be noted the field names and
name of the Text boxes are the same.