having a logo on a report...

[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?

 

[Guest]

To the OnPrint event of the report add the code

Me.[LogoName].Visible = (Me.[ComboName] = "TSWS")
Me.[Address].Visible = Not (Me.[ComboName] = "TSWS")

 

[stephendeloach via AccessMonster.com]

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

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?

 

[Guest]

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

 

[Damon Heron]

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

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

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?

 

[stephendeloach via AccessMonster.com]

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!

 

[Guest]

You do not need to embed your logo in a table only in the form.