On Thu, 13 May 2010 20:28:14 GMT, 1stAyd wrote:

> Greetings, Access Novice here.
>
> I have Line18 formatted as Visible = "NO" in Properties, and I want to make
> it visible depending on the value of certain fields. Why doesn't this code
> work when put in the "On Format" or "On Print" events of the Detail section?
>
> If [Inventory Posting Group] = "RESALE" Then Line18.Visible = "YES"
>
> BTW, I tried "TRUE" in place of "YES", and it still didn't work. TIA.

You've turned the Yes (no quotes) into "Yes" (a string value).
Anyway in VBA it should have been True (without the quotes) not Yes.
Yes is not a VBA constant. True is.

If [Inventory Posting Group] = "RESALE" Then Line18.Visible = True

A simpler expression would be:
Line18.Visible = [Inventory Posting Group] = "RESALE"

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Fri, 14 May 2010 17:41:06 GMT, 1stAyd via AccessMonster.com wrote:

> Now I'm really confused. As an attempt to simplify, I put this line into "On
> Format" of the "Detail" section:
>
> =[Me].[Line18].[Visible]=True
>
> but Line18 still isn't visible...... Thanks.

Not only do you appear to be confused but now I am as well <grin>

See Duane Hookums latest reply.
I suspect, as he does, that you are placing the code in the wrong
place.
Here is how to write code.
Click on the Event Tab of the report's Detail Section property sheet.
On the Format event line write:
[Event Procedure]
Click on the little button with 3 dots that appears on that line.
The Format event code window will appear.
The cursor will be flashing between 2 already existing lines of code.
Between those 2 lines write:

Line18.Visible = [Inventory Posting Group] = "RESALE"

Exit the window and save the VBA code.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail