Bobby Heid
bheid at appdevgrp.com
Thu Nov 18 12:26:38 CST 2004
Gustav,
Yes, that works also. Why would I need to put .Report on the end? It
already knows it is in the Reports collection?
I have never seen anything like that when referencing something on a form
either? Is there a .Form for the forms?
Also, what is Svar in the subject?
Thanks,
Bobby
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, November 18, 2004 12:37 PM
To: accessd at databaseadvisors.com
Subject: Svar: RE: [AccessD] Control reference question.
Hi Bobby
What happens if you try?
The use of .Report should be the recommended syntax ...
/gustav
>>> bheid at appdevgrp.com 18-11-2004 17:30:50 >>>
I dunno, it works as I have it. I have never used Report on the end like
you have it.
Bobby
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, November 18, 2004 11:09 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Control reference question.
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