Gustav Brock
Gustav at cactus.dk
Thu Nov 18 10:09:02 CST 2004
Hi Bobby Shouldn't it read: With Reports!Closeout!Closeout_GL_sub.Report If !txtSetBold <> 0 Then !txtGLEstPayroll.FONTBOLD = True !txtGLFinalPayroll.FONTBOLD = True Else !txtGLEstPayroll.FONTBOLD = False !txtGLFinalPayroll.FONTBOLD = False End If End With /gustav >>> bheid at appdevgrp.com 18-11-2004 16:53:24 >>> Now this is really weird. I played with it for over an hour yesterday and could not get it to work no matter how I changed it. I went back in a few minutes ago and changed the code from: With Reports!Closeout!Closeout_GL_sub If txtSetBold <> 0 Then !txtGLEstPayroll.FONTBOLD = True !txtGLFinalPayroll.FONTBOLD = True Else !txtGLEstPayroll.FONTBOLD = False !txtGLFinalPayroll.FONTBOLD = False End If End With TO With Reports!Closeout!Closeout_GL_sub If txtSetBold <> 0 Then txtGLEstPayroll.FONTBOLD = True txtGLFinalPayroll.FONTBOLD = True Else txtGLEstPayroll.FONTBOLD = False txtGLFinalPayroll.FONTBOLD = False End If End With And it now works. I hate it when Access does this to me. Thanks all. Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Thursday, November 18, 2004 9:09 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Control reference question. Well I don't understand that. just tried it on a report and it worked fine. Do you want to post the whole line of code that errored? -- Andy Lacey http://www.minstersystems.co.uk