Hi,
I created a report in Access 2003 which is based on http://support.microsoft.com/kb/328320
The report runs on a reasonably good speed at Access 2003 and Access 2007. But it is stalled when it runs on Access 2010.
Detail...
I need to use an image as watermark. Code from Microsoft's above example shows ZEROS when the current textbox is empty.
I want to hide those ZEROS from the watermark image.
So I wrote this...
Private Sub Detail1_Format(Cancel As Integer, FormatCount As Integer)
'*** to hide ZEROS on water marked logo starts
If Me("Col1") < 1 Then
Me("Col1").Visible = False
Else
Me("Col1").Visible = True
End If
'*** to hide ZEROS on water marked logo ends
' I have 26 columns -
In short, the report runs good on 2003/2007 but fails in 2010.
it works good if the above code is removed.
Can someone help me with this?
Best,
Ozair
Minggu, 12 Agustus 2012
[MS_AccessPros] CrossTab Query in 2010 [ report extremely slow on watermark image]
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar