[AccessD] If-Then in a report

Kathryn Bassett kathryn at bassett.net
Fri Jun 13 01:03:26 CDT 2003


Thanks again to Stuart, my report is almost exactly what I want (except final lining up etc):
http://altadenabaptist.org/images/Image2.jpg

Next, I want to know how to make the Connections *label* to only show up if there is content in the field.
Going back to the image that shows the layout:
http://altadenabaptist.org/images/Image1.jpg
you can see how it's set at present. I know how to trim in the content, but not how to make the label appear/disappear. My thoughts are:
If the field called "connections" is not blank, then print Connections followed by a colon and then a space, and then the contents of the Connections field.
I'm guessing it is done by somehow using the trim (& not using the label), but can't figure out the exact syntax.
I tried this:
=trim(Connections: & " " & [connections])
but it tells me I've entered an operand without an operator.

I need the correct syntax, and also need to know if I'm right that if the connections field is empty, it will not put anything, including the Connections: or is there some other solution?

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



More information about the AccessD mailing list