having a logo on a report...

  • Thread starter Thread starter stephendeloach via AccessMonster.com
  • Start date Start date
S

stephendeloach via AccessMonster.com

Im trying to have a company logo at the top of my report. The problem is that
I only want it when the reports "CompanyFrm" field is TSWS. My CompanyFrm
field is a dropdown box in the form that places the address of the company
from at the top of the report. Is there a way that when the dropdown box is
TSWS it places the logo at the top of the report instead of the address?
 
To the OnPrint event of the report add the code

Me.[LogoName].Visible = (Me.[ComboName] = "TSWS")
Me.[Address].Visible = Not (Me.[ComboName] = "TSWS")
 
OK. Where [LogoName] is, do i type C:\logo.bmp or just logo.bmp? and what do
I put in for [Address]? I have multiple addresses. Im guessing [ComboName]
is [CompanyFrom]? Sorry, Im not the best at this! Thanks

Ofer said:
To the OnPrint event of the report add the code

Me.[LogoName].Visible = (Me.[ComboName] = "TSWS")
Me.[Address].Visible = Not (Me.[ComboName] = "TSWS")
Im trying to have a company logo at the top of my report. The problem is that
I only want it when the reports "CompanyFrm" field is TSWS. My CompanyFrm
field is a dropdown box in the form that places the address of the company
from at the top of the report. Is there a way that when the dropdown box is
TSWS it places the logo at the top of the report instead of the address?
Click to expand...
Click to expand...
 
In the Field AfterUpDate Event (Try Below)

With Me
If .CompanyFrm="TSWS" Then
.AddressField.Visible=False
.CompanyLogo.Visible=True
Else
.AddressField.Visible=True
.CompanyLogo.Visible=False
End If
End With
 
What Ofer is saying that on the report you would add an image control. The
Logo image would be imbedded in Access, not linked. When the companyfrm
name is TSWS then the image control would be visible, else the textbox on
the report for the address would be visible.

Damon

stephendeloach via AccessMonster.com said:
OK. Where [LogoName] is, do i type C:\logo.bmp or just logo.bmp? and what
do
I put in for [Address]? I have multiple addresses. Im guessing
[ComboName]
is [CompanyFrom]? Sorry, Im not the best at this! Thanks

Ofer said:
To the OnPrint event of the report add the code

Me.[LogoName].Visible = (Me.[ComboName] = "TSWS")
Me.[Address].Visible = Not (Me.[ComboName] = "TSWS")
Im trying to have a company logo at the top of my report. The problem is
that
I only want it when the reports "CompanyFrm" field is TSWS. My
CompanyFrm
field is a dropdown box in the form that places the address of the
company
from at the top of the report. Is there a way that when the dropdown box
is
TSWS it places the logo at the top of the report instead of the address?
Click to expand...
Click to expand...
Click to expand...
 
I put the code in under the AfterUpdate Event and I get a compile error:
Method or data member not found. and AddressField is highlighted... I have
a feeling CompanyLogo will be highlighted next because I havent stored my
logo anywhere??? I finally read up on this and I have embedded my logo in a
table, im sure i should have done this before? Sorry! Thanks!
 
Back
Top