Run time error with Table based Text Boxes in Report

Massamiya

Registered User.
Local time
Today, 23:13
Joined
Jan 28, 2011
Messages
16
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.
 
Object does not support this property or Method means what it says.

so you have something called Me!PartName and that something does not have a ForeColor
 
Object does not support this property or Method means what it says.

so you have something called Me!PartName and that something does not have a ForeColor
Thanks for the response.
"PartName" is a textbox in the detail section of the report and
if I am not wrong the TextBox control has a Forecolor property.
 

Users who are viewing this thread

Back
Top Bottom