View Single Post
  #2  
Old May 13th, 2010, 10:21 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Conditionally Format A Line?

Assuming [Inventory Posting Group] is bound to a control in the report, you
should be able to use:
ME.Line18.Visible = (Me.[Inventory Posting Group] = "RESALE")

--
Duane Hookom
Microsoft Access MVP


"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.

.