[AccessD] If-Then in a report

Kathryn Bassett kathryn at bassett.net
Fri Jun 13 22:18:03 CDT 2003


Yeah, almost perfect now. Two really minor quibbles.

Here's the image again (I switched the old one, so you may have to refresh):
http://altadenabaptist.org/images/Image2.jpg
Although I have Connections: in the label, the colon doesn't show up. And for some reason, there is a period on the line right under the C in Connections. Know what causes that?

I can live with both, but would like to know what causes these two anomolies.

Thanks so much "you guys"!

--
Kathryn Rhinehart Bassett (Pasadena CA)
"Genealogy is my bag" "GH is my soap"
kathryn at bassett.net
http://bassett.net  

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bryan
> Carbonnell
> Sent: 13 Jun 2003 7:44:PM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] If-Then in a report
> 
> 
> On 13 Jun 2003 at 19:21, Kathryn Bassett wrote:
> 
> > won't even compile (yes, I've finally learned enough to remember that
> > step). It's A2k if that makes a difference. I zipped it (about 1mg
> > zipped) and it's at: http://altadenabaptist.org/abc.zip and the report
> > is: PhotoDirectory - Photos Done - Connections
> > 
> > I'm guessing that I'm still missing something.
> 
> Kathryn,
> 
> Here is the code you need, it's kind of a combination of all of the 
> suggertions:
> 
> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
> 'Image5.Picture = photo
> If Nz(connections, "") = "" Then
>     Me.Controls("Label17").Visible = False
>     Me.Controls("connections").Visible = False
> Else
>     Me.Controls("Label17").Visible = True
>     Me.Controls("connections").Visible = True
> End If
> End Sub
> 
> --
> Bryan Carbonnell - carbonnb at sympatico.ca
> I love deadlines. I like the whooshing sound they make as they fly 
> by. - Douglas Adams
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



More information about the AccessD mailing list